Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ok, i'm trying to create a formulas to calculate overtime hours for a
timesheet. 8 hours starts overtime so I have L11(total hours)-8/24. Now if my total hours are over 8 this works perfect but if there not I get a result of infinate #### and yes my column is wide enough! I have no idea what to do. I'v tried everything from IF statments to conditional formatting, I can't seem to figure this one out. Please help me or give me some ideas as to what to try. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Trouble | Excel Discussion (Misc queries) | |||
trouble with formula | Excel Discussion (Misc queries) | |||
Formula trouble | Excel Discussion (Misc queries) | |||
'IF' formula trouble | Excel Discussion (Misc queries) | |||
Trouble with formula | Excel Worksheet Functions |