| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum work hours to hours & nearest 10th of an hour
if you want to roundup to the next 10th minute try: =IF(MINUTE(SUMPRODUCT(($G$2:$G$100+$H$2:$H$100-$E$2:$E$100-$F$2:$F$100)*($H$2:$H$100<"")*($D$2:$D$100=M2)))= 0,SUMPRODUCT(($G$2:$G$100+$H$2:$H$100-$E$2:$E$100-$F$2:$F$100)*($H$2:$H$100<"")*($D$2:$D$100=M2)),R OUNDUP(SUMPRODUCT(($G$2:$G$100+$H$2:$H$100-$E$2:$E$100-$F$2:$F$100)*($H$2:$H$100<"")*($D$2:$D$100=M2))*1 44,0)/144) or look again in OneDrive Regards Claus B. What could be better than all those choices! Thanks a million Claus. Howard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| work hours with different hour prices | Excel Worksheet Functions | |||
| Converting work hours to day/hours/minutes | Excel Discussion (Misc queries) | |||
| Determining work hours between dates / hours | Excel Worksheet Functions | |||
| total work hours for 24 hour on-call schedules | Excel Discussion (Misc queries) | |||
| Apply a macro to all sheets - save me from hours and hours of work | Excel Programming | |||
Hybrid Mode
