subtracting day times

[boehnc]

Just not getting this time calculation formula.

in Cell:

A1 12/01/2010
B1 11:48:00 AM
C1 12/02/2010
D1 12:42:00 PM

Im trying to calculate the number of minutes between the two dates/times.

(c1+d1) - (a1+b1)

but can't seem to figure this simple calc out..any help? Thanks!

 

[VoG]

To get decimal minutes try

=((C1+D1)-(A1+B1))*60*24

and format as Number.

 

[T. Valko]

Just not getting this time calculation formula.

in Cell:

A1 12/01/2010
B1 11:48:00 AM
C1 12/02/2010
D1 12:42:00 PM

Im trying to calculate the number of minutes between the two dates/times.

(c1+d1) - (a1+b1)

but can't seem to figure this simple calc out..any help? Thanks!

If you want the number of minutes as a decimal value...

=((C1+D1)-(A1+B1))*1440

Format as General or Number

 

[Just Jan]

E1 =(C1+D1)-(A1+B1)
format as [m]