Difference between dates

[Susan]

How do I set up a function to calculate hours worked
between two dates?

 

[Vasant Nanavati]

Hi Susan:

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

Regards,

Vasant.

 

[Arvi Laanemets]

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