calculate the time between to dates and times

G

Guest

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?
 
G

Guest

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.
 
G

Guest

sorry, I meant:

=B1-A1


--
Hope that helps.

Vergel Adriano


Vergel Adriano said:
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 said:
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?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
Difference between 2 times 2
Access Access - Elapsed Time between Records 5
Calculating Time 2
Calculation of Overlap Outage Hours 17
Calc Number of Months PER YEAR Between Dates 2
Calculate the number of hours between two dates and times 1
calculate elapsed time between dates and times 2

Top