I need to add daily hours of work, an average days works adds up to 19 hours. I need to add at least one months worth of hours. Any ideas as to the best formula to use?
ADVERTISEMENT
Try this formula and format the cell as [h]:mm
=IF(COUNT(F4:G4)<2,"",IF(F4=G4,"24:00"+0,MOD(G4-F4,1)))
Sheet1
* F G H I J K 4 10:00 PM 10:00 PM 24:00 * TOTAL HRS: 34:30 5 10:00 PM 8:30 AM 10:30 * * *
<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 91px"><COL style="WIDTH: 64px"></COLGROUP><TBODY>
</TBODY>
Spreadsheet Formulas
Cell Formula H4 =IF(COUNT(F4:G4)<2,"",IF(F4=G4,"24:00"+0,MOD(G4-F4,1))) K4 =SUM(H:H) H5 =IF(COUNT(F5:G5)<2,"",IF(F5=G5,"24:00"+0,MOD(G5-F5,1)))
<TBODY>
</TBODY>
<TBODY>
</TBODY>
Excel tables to the web >> Excel Jeanie HTML 4
You have not still provided any data hopfully Scott solution will work.
On the other hand have you tried to use Custom Format [h]:mm?
This will go beyond 24 hours.