Hi,
I have column A and B which contain hours and minutes in decimal. A1 = 15.9, B1 = 10.1.
How do I subtract these numbers and have the result appear in C1 in hours and minutes.
So what I need is C1 = 15 hrs 54mins - 10 hrs 6mins.
Thanks,
Gerry
I have column A and B which contain hours and minutes in decimal. A1 = 15.9, B1 = 10.1.
How do I subtract these numbers and have the result appear in C1 in hours and minutes.
So what I need is C1 = 15 hrs 54mins - 10 hrs 6mins.
Thanks,
Gerry