View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kjaltrik Kjaltrik is offline
external usenet poster
 
Posts: 5
Default Working night and day..... Timesheet

In Out In Out The total time I
get Overtime
15:00 18:30 19:20 02:00 -13,83 0,00

I'm using this Formula:
=IF((((D13-C13)+(F13-E13))*24)24;8;((D13-C13)+(F13-E13))*24). Why doesn't
this work? I get negative hours in the total worked hours and no overtime...
My computer doesn't understand the new comming day...

This formula works when I'm working daytime...

Hope there's somebody that can help me

Thnx!!