Difference between dates

  • Thread starter Thread starter Susan
  • Start date Start date
Hi Susan:

That would depend on how many hours a day were worked. Can you be more
specific?

Regards,

Vasant.
 
Hi

When the start and end times are formatted as DateTime (p.e. "dd.mm.yyy
hh.mm"), then simply
=EndTime-StartTime
and format the result as Custom "[h]:mm"

When the start and end times are formatted as Time, and the difference never
reaches 24 hrs, then
=EndTime-StartTime + (StartTime>EndTime)
and format the result as Time ("h:mm")


Arvi Laanemets
 
Back
Top