Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding time in excel
hey all,
is there way to add time in excel? for instance, i want to take 58 min and add 3min giving 61min. thanks, rodchar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding time in excel
Hi,
I think there's a banana skin waiting for me here because these don't look like formatted times to me but supposing they are then it's simple addition =a1+a2 formatted as [mm].ss Mike "rodchar" wrote: hey all, is there way to add time in excel? for instance, i want to take 58 min and add 3min giving 61min. thanks, rodchar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding time in excel
sorry bout that, should have phrased it better...
turns out i can do 15:34 + 0:20 to give me what i need. "Mike H" wrote: Hi, I think there's a banana skin waiting for me here because these don't look like formatted times to me but supposing they are then it's simple addition =a1+a2 formatted as [mm].ss Mike "rodchar" wrote: hey all, is there way to add time in excel? for instance, i want to take 58 min and add 3min giving 61min. thanks, rodchar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Figuring and adding time in Excel | Excel Worksheet Functions | |||
Adding hours to time in Excel | New Users to Excel | |||
Adding time Values up in Excel | Excel Worksheet Functions | |||
Adding time in Excel | Excel Worksheet Functions | |||
Adding time in Excel | Excel Worksheet Functions |