Formula help

dallasazcat · Dec 8, 2024

Greatly appreciate if someone could help me create a formula to figure out the duration in hours from a list, such as this:

10/26: 9:18 - 10:44
10/27: 7:17 - 10:00
10/28: 7:24 - 9:40
11/5: 7:23 - 10:04
11/6: 8:30 - 10:28
11/7: 7:05 - 9:38
11/10: 7:10 - 10:52
11/11: 11:58 - 1:28
11/12: 6:54 - 9:24

6StringJazzer · Dec 8, 2024

Your question needs to be more detailed to get a specific answer you can use.

Do you hours line-by-line? Or do you want a single total of all hours? How is your data organized? Is each line you are showing here text in a single cell? That is not good data design and will make this harder. What do you want your result to look like?

I would split each line into three cells. I had to make some assumptions about which times are AM and PM.

$scratch.xlsm

A

B

C

D

1

Elapsed Time

2

10/26/2024

9:18 AM

10:44 AM