•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why are my time duration calculations off?
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!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#real-time data collaboration
#time duration
#1.00 hours
#h:mm AM/PM
#calculations
#format of cells
#correct answer
#decimal places
#A2
#B2
#C2
#number
#error
#submitted
#reddit
#explanation