Subtract Dates based on 24 hour system

W

Well Missy

I have an equation where I am subtract time based on 24 hours. For example,

1:00 a.m. - 23:00 p.m. = 2

how do I build the equation to obtain an answer of 2 hours? Help.
 
R

Ron Coderre

Since you're crossing over midnight, try something like this:

For
A1: 1:00
B1: 23:00
C1: =MOD(+A1-B1,1)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
S

Sandy Mann

Missy,

Assuming:
23:00 pm means 11:00 PM (23:00 pm is text NOT an Excel time)

A1= 01:00 (or 1:00 AM)
B1= 23:00 (or 23:00 PM)

try:
=((A1-B1)+(A1<B1)) formatted as time or

=((A1-B1)+(A1<B1))*24 formatted as General for the number 2 or

=MOD(A1-B1,1) for time or

=MOD(A1-B1,1)*24 for number

--
HTH

Sandy
[email protected]
[email protected] with @tiscali.co.uk
 
Top