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