Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding time
I want to add 847 minutes to 7:31 AM and get 9:53 PM. I have several rows of
data : Start Time - formatted as 7:31 AM Duration - formatted as a number that equals minutes Time Leaving - formatted same as Start Time I can do this manually each row at a time, but there are 60,000+ rows this month... Has anybody come up with a consolidated set of formulas to do this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time [t]:mm:ss | Excel Worksheet Functions | |||
Adding time | Excel Worksheet Functions | |||
adding time | Excel Discussion (Misc queries) | |||
Time log adding time from separate sheets | New Users to Excel | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) |