Length of time from date/time custom format


A

Andrew

I am working with a database that uses one of the custom date/time formats,
specifically m/d/yyyy h:mm. I want to calculate the time difference between
two cells in this format; however, when I do a simple subtraction (for
example =A1-B1) the result is displayed again as a date and time. What I want
is to be able to determine the difference in time between the two values (for
example, the difference between 1/2/2000 13:00 and 1/1/2000 12:00 would be 1
day, 1 hour (or 25 hours, or 1500 minutes). I appreciate any advice!
 
Ad

Advertisements

Ad

Advertisements

P

Pete_UK

You can subtract them like you have tried, but you need to give the
cell with the formula in a different format, using Custom, such as:

[h]" hours"

or:

[m]" minutes"

Hope this helps.

Pete
 

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

Top