Good day!
I have a table that looks like
<TBODY>
</TBODY>
Hours column is formatted as such, h "hours," m "minutes" and is a calculated column;
I need to calculate the Total Hours. In this example, it should say 16 hours, 30 minutes. I tried using a SUM, but it only seems to show the maximum for some reason. Can anyone help me?
I have a table that looks like
Day | IN | OUT | IN | OUT | Hours |
1-Jul | 8:00 | 12:00 | 13:00 | 17:00 | 8 hours, 0 minutes |
2-Jul | 8:00 | 12:00 | 13:00 | 17:30 | 8 hours, 30 minutes |
Total Hours |
<TBODY>
</TBODY>
Hours column is formatted as such, h "hours," m "minutes" and is a calculated column;
Code:
=(e10-d10)+(g10-f10)
I need to calculate the Total Hours. In this example, it should say 16 hours, 30 minutes. I tried using a SUM, but it only seems to show the maximum for some reason. Can anyone help me?
Last edited: