lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I am trying to add time but it does not work. Please see the excel file in the link.
in cell P = SUM(C15:O15)
But it is giving me 0
I tried to format to [h]:mm but did not help. Not sure what else I could have done. I also multiple the SUM(C15:O15) * 24 but still 0:00:00 shown?! I am copying the row I want to add here as well
<tbody>
</tbody>
Thank you so much.
https://drive.google.com/file/d/1Tn1e73RuyRh4W4Y250VX5SXnr-HAeiHA/view?usp=sharing
I am trying to add time but it does not work. Please see the excel file in the link.
in cell P = SUM(C15:O15)
But it is giving me 0
I tried to format to [h]:mm but did not help. Not sure what else I could have done. I also multiple the SUM(C15:O15) * 24 but still 0:00:00 shown?! I am copying the row I want to add here as well
Total | 40:03:28 | 44:38:40 | 06:55:37 | 21:05:50 | 03:04:55 | 01:42:12 | 01:31:29 | 14:51:06 | 11:01:44 | 22:53:40 | 49:56:10 | 103:31:49 | 95:24:02 | 0:00:00 |
<tbody>
</tbody>
Thank you so much.
https://drive.google.com/file/d/1Tn1e73RuyRh4W4Y250VX5SXnr-HAeiHA/view?usp=sharing