Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The HH:MM function
Im making a spreadsheet which caluclates how much training certain people
have done in hours. For instance on one day someone may do 10 hours 30mins (represented in the spreadsheet as 10:30) and for the next four days did the same. What i would like is a number in my total column like this 52 hours 30mins (52:30) however the "total" cell wont exceed over 24:00, im sure its supposed not to exceed that because of the hh:mm function im using, but i wondered if anyone could tell me a way around this? Thanks |
#2
|
|||
|
|||
Chris, Format all the cells you intend to use as time format in the following manner: [hh]:mm To do this pull down Format/Cells/Custom and enter into the TYPE box the format above INCLUDE THE SQUARE BRACKETS AROUND THE HH This will express all time as hours regardless of whether it is less than 24 hours or not Cheers Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=398511 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |