Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding time
If I have the time listed to do different jobs in minutes and seconds and I
want to total them, what formatting do I use? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding time
If A1 displays 2:25 and B1 displays 4:55, then the formula =A1+B1 in C1 will
result in 7:20 Actually, Excel thinks you mean 2 hours, 25 mins, 0 seconds so C1 needs to be formatted the same as A1 and B1 (h:mm) To be precise you need 0:2:25 and 0:4:55 If hours exceed 24 you need forma [h]:mm:ss Tell us what you have tried and what problems you have hit on best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Liz" wrote in message ... If I have the time listed to do different jobs in minutes and seconds and I want to total them, what formatting do I use? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding time
If you want the answer to be in minutes & seconds, use [m]:ss as the format
for the answer cell. If you want hours, minutes, & seconds, use [h]:mm:ss It doesn't matter which of the Excel time formats you use for display in the input cells, as format affects only the display, not the underlying value. Remember when you are inputting your data that 12:34 will be interpreted as hh:mm, not mm:ss You'll need 0:12:34 or 12:34.0 to get it to recognise the time as mm:ss -- David Biddulph "Liz" wrote in message ... If I have the time listed to do different jobs in minutes and seconds and I want to total them, what formatting do I use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding time | Excel Worksheet Functions | |||
Adding time | Excel Worksheet Functions | |||
Time log adding time from separate sheets | New Users to Excel | |||
Adding Time | Excel Worksheet Functions | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) |