Hey guys,
I am in need of a formula that has the duration in hours and minutes based off of the time lengh in two different cells.
This is an outline of what I currently have:
F8 = 1330 (1:30PM)
G8 = 2200 (10:00PM)
H8 = 8.5 hours (I would need a formula to output this based on F8 and G8)
Any ideas?
I am in need of a formula that has the duration in hours and minutes based off of the time lengh in two different cells.
This is an outline of what I currently have:
F8 = 1330 (1:30PM)
G8 = 2200 (10:00PM)
H8 = 8.5 hours (I would need a formula to output this based on F8 and G8)
Any ideas?