View Single Post
  #1   Report Post  
 
Posts: n/a
Default Calculation of full hours

Hi,

I need an excel sheet that calculates the amount of hours I put in at
work at the end of each month. I know that it can be done with a 24
hours clock, but I have troubles calculating the amount of hours i
worked if the start and end are not in "the same day" - as in, if i put
13:00 to 15:00, it gives 2:00 hours but if I put 23:00 to 02:00 it only
gives 2 hours again...

anyone knows what function i'm supposed to use in order to fix that
problem?

thankyou!

~mo