M
moriel
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
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