W
Wilfred
How can I calculate elapsed time?
I created a simple spreadsheet with column headings "Start Time" and "End Time". I want to calculate the time, in hours and minutes, between the two values.
For example:
A B C
1 10:45 17:30
2 09:51 15:17
3 13:27 17:01
Is there a way for Excel to return a value for C1, C2, and C3 that represents the actual amount of time between A1 and B1, A2 and B2, A3 and B3?
Also, can Excel return a value for the cumulative time in C1 through C3?
Thanks in advance,
Wilfred
I created a simple spreadsheet with column headings "Start Time" and "End Time". I want to calculate the time, in hours and minutes, between the two values.
For example:
A B C
1 10:45 17:30
2 09:51 15:17
3 13:27 17:01
Is there a way for Excel to return a value for C1, C2, and C3 that represents the actual amount of time between A1 and B1, A2 and B2, A3 and B3?
Also, can Excel return a value for the cumulative time in C1 through C3?
Thanks in advance,
Wilfred