Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate time
I need to track time? In col. j2 & k2 are formated with
custom H:MM:SS. In L2 im looking to get the span of time in H:MM:SS. In M2 average span of time (cumul)?? any feed back would of great help. thank you Ken |
#2
|
|||
|
|||
L2: =K2-J2
M2: =SUM($L$2:L2) and copy down. Make sure the M cells are formatted as [hh]:mm:ss to cater for more than 24 hours -- HTH RP (remove nothere from the email address if mailing direct) "Ken" wrote in message ... I need to track time? In col. j2 & k2 are formated with custom H:MM:SS. In L2 im looking to get the span of time in H:MM:SS. In M2 average span of time (cumul)?? any feed back would of great help. thank you Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate time difference to the half hour | Excel Worksheet Functions | |||
How to calculate time between two dates? | Setting up and Configuration of Excel | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) |