Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialGeo Gs
2,785 Pointshow can i change he MODE format if im on excel i do not see the DURATION option
on excel i see almost every option as in google spread sheet program but i cannot find the duration option please help as i need to work with excel
1 Answer
Alex Life
16,114 PointsDuration is a format of time, or possibly a special format. Should just be able to use an hour:minute:second format though.
codyl
4,704 Pointscodyl
4,704 PointsRight click the cell, chose "FORMAT CELLS", then while on the NUMBER tab, chose "TIME". The 4th option down will change it to the same format as the video ("13:30:55")