Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cumulative Time Problem calculating more than 24 hours.
Hi,
I need to create a spreadsheet that can convert time into hours, the inbuilt functions only return times within a 24hour period which is completely useless to me. I need to give a start date & time, i.e 24 August 2004 09:15 and an end date/time 24 August 2005 11:23 and have it return the total running time in a variety of formats, including plain simple total hours (i.e. one years worth plus a couple). Any ideas how to do this. I want to be able to keep a running total, as well but I can probably figure it out once I can get the calculation for the total (greater than 24 hours) hours working. Regards J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating diff between date/ time only between certain hours | Excel Discussion (Misc queries) | |||
calculating time for late hours | Excel Worksheet Functions | |||
Calculating Time in Hours and round it up. | New Users to Excel | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Calculating time, hours and minutes | Excel Discussion (Misc queries) |