Working night and day..... Timesheet

G

Guest

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!!
 
G

Guest

Try this to get total hours worked (as decimal hours i.e. 6 hours 30 minutes
will be shown as 6.50 hours)

=((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24

HTH
 
G

Guest

Try this to get total hours worked (as decimal hours i.e. 6 hours 30 minutes
will be shown as 6.50 hours)

=((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24

HTH
 
G

Guest

Thank you very much!!! It worked.

But now the overtime cell still stands on zero...
I have overtime over 7,5 hours

The formula I use there is
=IF(((D13-C13)+(F13-E13))*24>7,5;((D13-C13)+(F13-E13))*24-7,5;)

Toppers skrev:
 
G

Guest

Thank you very much!!! It worked.

But now the overtime cell still stands on zero...
I have overtime over 7,5 hours

The formula I use there is
=IF(((D13-C13)+(F13-E13))*24>7,5;((D13-C13)+(F13-E13))*24-7,5;)

Toppers skrev:
 
G

Guest

Overtime hours:

=MAX(G1-7.5,0) where G1 contains total hours worked

OR

=MAX(((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24-7.5,0)

HTH
 
G

Guest

Overtime hours:

=MAX(G1-7.5,0) where G1 contains total hours worked

OR

=MAX(((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24-7.5,0)

HTH
 
G

Guest

Thank you very much for your time and help!

Everything is working good now!!



Toppers skrev:
 
G

Guest

Thank you very much for your time and help!

Everything is working good now!!



Toppers skrev:
 

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

Need help with my timesheet? regular, 50% and 100% 8
Microsoft Excel Formula "IF" to create a timesheet 3
Problem with calculating hours in timesheet? (sysgulv) 3
Adding Hours Worked Correctly 3
Calculate time in a cell 3
Negative Dates and/or Times 3
Formula omits adjacent cells error message 4
Why Am I getting a blank in the result cell? 4

Top