ExcelBanter - counting periods Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - counting periods Excel (https://www.excelbanter.com/excel-worksheet-functions/157176-counting-periods-excel.html)

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

counting periods Excel

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

--
Regards,

Peo Sjoblom

"Eric" wrote in message
...
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