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!
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!