calculate the time between to dates and times
 

I need to calculate the total time elapsed between two dates and times. What
should I do? Here's an example. Start date/time is 8/24/07 06:15 and the
ending date/time is 8/26/07 12:00 (noon). How do I find the total elapsed
time?

calculate the time between to dates and times
 

Assuming 8/24/07 06:15 is in A1 and 8/26/07 12:00 is in B1, in C1 enter this
formula:

=A1-B1


then, apply a custom format like [h]:mm to C1.



--
Hope that helps.

Vergel Adriano


"Purple Queen" wrote:

I need to calculate the total time elapsed between two dates and times. What
should I do? Here's an example. Start date/time is 8/24/07 06:15 and the
ending date/time is 8/26/07 12:00 (noon). How do I find the total elapsed
time?

calculate the time between to dates and times
 

sorry, I meant:

=B1-A1


--
Hope that helps.

Vergel Adriano


"Vergel Adriano" wrote:

Assuming 8/24/07 06:15 is in A1 and 8/26/07 12:00 is in B1, in C1 enter this
formula:

=A1-B1


then, apply a custom format like [h]:mm to C1.



--
Hope that helps.

Vergel Adriano


"Purple Queen" wrote:

I need to calculate the total time elapsed between two dates and times. What
should I do? Here's an example. Start date/time is 8/24/07 06:15 and the
ending date/time is 8/26/07 12:00 (noon). How do I find the total elapsed
time?