| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum IF function From time to number not working??
Hi,
I am having a very large problem that may have the simplest solution! Wondering if anyone can help?? I have in Cell G8 the following formula: =IF(G5="",0,(G7-G5-G6)*24) The problem I am encountering is that it value the cell as 0.4999998 and if I ROUNUP it vlaues it at 1.0 and if i just ROUND it values it as 0.9999998?? Is there any way of making it round correctly?? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| working out a sum in time? | Excel Discussion (Misc queries) | |||
| Working with Time | Excel Worksheet Functions | |||
| formula help working with time | Excel Discussion (Misc queries) | |||
| Number of employees working at given time | Excel Discussion (Misc queries) | |||
| working with time functions | Excel Discussion (Misc queries) | |||
Threaded Mode
