Explorador
New Member
- Joined
- May 27, 2021
- Messages
- 9
- Office Version
- 365
- Platform
- MacOS
MrExcelPlayground2.xlsm | |||
---|---|---|---|
I | |||
23 | 12:03:01 | ||
24 | 12:03:45 | ||
25 | 12:04:02 | ||
26 | 12:03:05 | ||
27 | 12:13:53 | ||
28 | 60:27:46 | ||
Sheet29 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I28 | I28 | =SUM(I23:I27) |
Hi James,It's a data entry problem.
MrExcelPlayground2.xlsm
I 23 12:03:01 24 12:03:45 25 12:04:02 26 12:03:05 27 12:13:53 28 60:27:46 Sheet29
Cell Formulas Range Formula I28 I28 =SUM(I23:I27)
The formatting is the key. Put the monthly entries in 24 hour time. You are getting 12:03 AM, instead of PM. fix it by adding 0.5.
The formatting of the sum should be "[h]:mm:ss"
Inbound_Marketing_Specialist_-_Test.xlsx | |||
---|---|---|---|
F | |||
8 | Call Length | ||
9 | 0:03:01 | ||
10 | 0:03:55 | ||
11 | 0:04:09 | ||
12 | 0:03:30 | ||
13 | 0:03:38 | ||
14 | 0:02:10 | ||
15 | 0:03:00 | ||
16 | 0:03:49 | ||
17 | |||
Reporting test |