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 |
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 |
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 |
All times are GMT +1. The time now is 09:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com