Time sheet Formula

E

Ed Davis

I have a sheet where I am trying to calculate hours worked against hours
allowed.

I am able to add the hours worked in a period but when I try to subtract the
hours worked from the hours allowed I get an error if the hours worked are
lower than what is allowed.

This is what it looks like:

hours worked 42:26:00 29:31:00
hours allowed 41:00:00 38:00:00
Over Budget 1:26:00 ########################


The formula for over budget is as follows:
=IF(D29<>0,(D29-D30)," ")

Does anyone know how to make this work show it shows me the correct
information?

Thanks in advance.
Ed Davis
 
T

T. Valko

The problem is that Excel won't display negative time unless you use the
1904 date system. The 1904 date system can cause other problems so I would
recommend not using it.

What you can do is use a decimal format instead.

=IF(D29<>0,(D29-D30)*24,"")

Format as GENERAL

Biff
 
J

JE McGimpsey

What problems can possibly be caused by the 1904 date system? It can
display negative times if the OP chooses, and it doesn't include any
imaginary dates the way the 1900 system does...

Certainly blindly mixing date systems can result in problems when
copying from a workbook using one system to a workbook using the other,
but that's not a problem caused by either system...
 
T

T. Valko

but that's not a problem

Biff

JE McGimpsey said:
What problems can possibly be caused by the 1904 date system? It can
display negative times if the OP chooses, and it doesn't include any
imaginary dates the way the 1900 system does...

Certainly blindly mixing date systems can result in problems when
copying from a workbook using one system to a workbook using the other,
but that's not a problem caused by either system...
Click to expand...
 
Top