Time format to decimal time in Numbers for MAC
Hello,
Cannot find the answer to this anywhere else, so sorry if it does appear somewhere on this forum.
I want to convert the following:
Cell A1 contains time format of hours and minutes. I want to place the decimalised equivalent of that time referenced in A1 in Cell A2
Example
Time HH/MM. 1h36m
Time Decimal. 1.6Hours
How do I do it?
Much appreciate your help
Jon