SelinaR
Board Regular
- Joined
- Feb 2, 2012
- Messages
- 65
- Office Version
- 2021
- Platform
- Windows
- Mobile
- Web
Morning all....
Tried various ways to convert the following into showing me hours... please help (I dont want it in a clock format - just a formula answer)
Minutes taken
0.12
0.35
0.50
=SUM(a1:a3) : Answer 0.97 (but I want it to look like 1.37 --> 1 hour and 37 minutes)
please help????
THANKS IN ADVANCE!!!
Tried various ways to convert the following into showing me hours... please help (I dont want it in a clock format - just a formula answer)
Minutes taken
0.12
0.35
0.50
=SUM(a1:a3) : Answer 0.97 (but I want it to look like 1.37 --> 1 hour and 37 minutes)
please help????
THANKS IN ADVANCE!!!