Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I have a spreadsheet which contains Times, and I wish to add minutes, anyone know the formula required? E.g Time is 0615 and I wish to add 248 minutes, although this could be any value of minutes. I've tried something like : (Where A1 = 06:15:00 ) = A1 + 245, but that doesn't work obviously, so I tried to isolate the Minute portion using MINUTE(A1) + 245, but this doesn't take in to account of the hours. Does anybody have a simple formula which can perform this? Kind Regards Ricky |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding minutes. | Excel Worksheet Functions | |||
How do I sum increments of minutes and seconds | Excel Worksheet Functions | |||
help neede with adding times | Excel Discussion (Misc queries) | |||
Adding hours and minutes.. | Excel Discussion (Misc queries) | |||
Adding Times | Excel Worksheet Functions |