ExcelBanter - View Single Post

On 8 Sep 2005 09:48:31 -0700, wrote:

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

=EndTime-StartTime+(EndTime<StartTime)

--ron