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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
work hours with different hour prices 12
Calculating date/time intervals?? 1
difference of date/time only calculating workingdays/hours 4
Calculating number of workdays between 2 dates 14
Difference between dates 9
Difference between date and time 7
Difference (weekdays) between two dates 5

Back
Top