Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time sheet formula? | Excel Discussion (Misc queries) | |||
Help With Time Sheet Formula | Excel Discussion (Misc queries) | |||
Formula for a time sheet | Excel Discussion (Misc queries) | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
formula to calculate a time sheet | Excel Worksheet Functions |