counting periods Excel
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
|