1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Why are my time duration calculations off?

https://preview.redd.it/dib8qtz4gyig1.png?width=823&format=png&auto=webp&s=018e16b93366cea3d53a07e83bbc9c8234cac31a

Correct answer should be 1.00 hours not -13.38?

Format of cells:

A2 = h:mm AM/PM

B2 = h:mm AM/PM

C2 = Number with two decimal places

Many thanks in advance!

submitted by /u/CorruptionAllAround
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article