counting periods Excel

E

Eric

Hello,

I have a problem with counting periods in Excel. When I try to count
(A1) 7-5-2007 8:00 and (B1) 10-06-07 8:00 the result is a period of
3:0:00 (dd:hr:min)
(formula: B1-A1) and
34:00:00 (dd:hr:min)
(formula: =INTEGER(B1-A1)&":"&TEKST(B1-A1;"uu:mm" )

Excel doesn't count over a month.

Any solutions for my problem?

Thanks
 
P

Peo Sjoblom

Works fine for me, using your formula

=INT(B1-A1)

returns 34 formatted as General

to get the time use

MOD(B1-A1,1)


=INT(B1-A1)&":"&TEXT(MOD(B1-A1,1),"hh:mm")


which would be


TEKST(REST(B1-A1;1);"uu:mm")

returns 34:00:00

if I change the time in A1 to 12:00 it returns

33:20:00
 
Top