Calculating elapsed minutes from two different date/time entries

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

 

[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

 

[bubba]

Thanks, Pete!

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

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.

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete