View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default 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