R
Robin
Im trying to average duration of time, and have not found the correct way to
format the cell.
First, I have a start and end time. I need to calculate the difference
between the two in hours, and the duration usually exceeds 24 hours. Then I
need to average the time durations.
Sample:
A1 (start time): 3/27/2008 8:35 Custom format: m/d/yyyy h:mm
B1: (end time) 3/30/08 13:00 Custom format: m/d/yyyy h:mm
C1: (duration) formula B1-A1 - value = 76:25 Custom format: [h]:mm (this
seemed to be the only format that returned the duration in hours
appropriately)
I average the values in column C, and end up with a number greater than my
longest duration. Custom format of [h]:mm or m/d/yyyy h:mm do not provide
correct results. Suggestions are greatly appreciated.
THANX!
format the cell.
First, I have a start and end time. I need to calculate the difference
between the two in hours, and the duration usually exceeds 24 hours. Then I
need to average the time durations.
Sample:
A1 (start time): 3/27/2008 8:35 Custom format: m/d/yyyy h:mm
B1: (end time) 3/30/08 13:00 Custom format: m/d/yyyy h:mm
C1: (duration) formula B1-A1 - value = 76:25 Custom format: [h]:mm (this
seemed to be the only format that returned the duration in hours
appropriately)
I average the values in column C, and end up with a number greater than my
longest duration. Custom format of [h]:mm or m/d/yyyy h:mm do not provide
correct results. Suggestions are greatly appreciated.
THANX!