Calculating elapsed minutes from two different date/time entries

B

bubba

How do I calculate the total elapsed minutes between these two entries?


1/8/08 4:45 PM

1/9/08 2:15 PM


Will be making one or more entries per day in the above cell format.

Thanks.
 
P

Pete_UK

Just subtract them:

=B1-A1

where B1 is the later date. Ensure that the cell with the formula in
is formatted as [hh]:mm using a Custom format.

Hope this helps.

Pete
 
B

bubba

Thanks, Pete!

I knew it was something simple, but had the formatting wrong.



Pete_UK said:
Just subtract them:

=B1-A1

where B1 is the later date. Ensure that the cell with the formula in
is formatted as [hh]:mm using a Custom format.

Hope this helps.

Pete

How do I calculate the total elapsed minutes between these two entries?

1/8/08 4:45 PM

1/9/08 2:15 PM

Will be making one or more entries per day in the above cell format.

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

Access Access - Elapsed Time between Records 5
Calculating total elapsed minutes between two dates 1
Calculating Time Elapsed in Excel 10
Calculating Elapsed Time 2
calculating elapsed time over a period of days 2
Format for Time Elapsed in Decimal 4
Calculate elapsed time excluding specific timeframe 10
Calculating hours elapsed when date/ time > 24 hours 1

Top