Calculating elapsed time

[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

 

[Paul B]

Wilfred, In C1 put =B1-A1 and copy down in C4 put =SUM(C1:C3) format them as 37:30:55 or custom [h]:mm:ss

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
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

 

[M. lane]

Format columns A and B as custom "hh:mm:ss",
Format column C as number,
Paste this formula in cell c1:
=IF(A2<A1,HOUR(A2)-HOUR(A1)+24,HOUR(A2)-HOUR(A1))+(MINUTE(A2)-MINUTE(A1))/60
now highlight cell C1 -C3 and hold CTRL + R.
In cell C4 type or paste this formula: =SUM(C1:C3)

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

 

[Wilfred]

Thanks!

I had to change the formula in C1 to compute the difference between the
cells in columns A & B instead of Rows 1 & 2 but it works!

=IF(B1<A1,HOUR(B1)-HOUR(A1)+24,HOUR(B1)-HOUR(A1))+(MINUTE(B1)-MINUTE(A1))/60

Thanks again!

 

[M. lane]

Oops, thought I had it right for you. but as long as you have it working,
good.

 

[Tom Ogilvy]

Simpler would be

=B1-A1+(B1<A1)
format as [hh]:mm

if you want it in hours like 9.75

=(B1-A1+(B1<A1))*24

 

[Wilfred]

Thank you!

Simpler would be

=B1-A1+(B1<A1)
format as [hh]:mm

if you want it in hours like 9.75

=(B1-A1+(B1<A1))*24

--
Regards,
Tom Ogilvy

Thanks!

I had to change the formula in C1 to compute the difference between the
cells in columns A & B instead of Rows 1 & 2 but it works!

=IF(B1<A1,HOUR(B1)-HOUR(A1)+24,HOUR(B1)-HOUR(A1))+(MINUTE(B1)-MINUTE(A1))/60

Thanks again!

=IF(A2<A1,HOUR(A2)-HOUR(A1)+24,HOUR(A2)-HOUR(A1))+(MINUTE(A2)-MINUTE(A1))/60

the
two