Forum Discussion
ReliableBoy2
Apr 07, 2023Copper Contributor
Using TimeValue function to display hours and minutes spent.
Hi, I am stuck with the following issue, https://docs.google.com/spreadsheets/d/1TK1YrYzYgD-Sqgf4PmycPKbZ-iJH7ppD/edit?usp=share_link&ouid=101514595417469444876&rtpof=true&sd=true The abo...
JoeUser2004
Apr 08, 2023Bronze Contributor
If this is what you want, it really is very simple.
Formulas:
Q9: =IF(OR(O9="",P9=""), "", IF(HOUR(P9-O9)=0, "", HOUR(P9-O9)))
R9: =IF(OR(O9="",P9=""), "", MINUTE(P9-O9))
Copy Q9:R9 into Q10:R13
Alternative:
Q9: =IF(OR(O9="",P9=""), "", HOUR(P9-O9))
with the following Custom format:
[=0]""; General
However, note that the value in Q13 will be zero, even if it appears to be blank.