| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours
All,
I'm trying to add hours per week B2:G2 but i cannot make it work please help. I have this formula to add the hours daily. the formula needs to return hours worked in the same format =+IF(+(B3-B2)*24<0,-(B3-B2)*24,+(B3-B2)*24)+IF(+(B5-B4)*24<0,-(B5-B4)*24,+(B5-B4)*24) -- Regards YM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help adding hours exceeding 24 hours | Excel Worksheet Functions | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| adding like job hours | Excel Discussion (Misc queries) | |||
| Adding hours and minutes | Excel Discussion (Misc queries) | |||
| Adding hours and minutes | Excel Discussion (Misc queries) | |||
Threaded Mode
