garypea123
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 221
- Office Version
- 365
- Platform
- Windows
Easy one for you.
I have an export which gives my days off by fraction.
Example: 7.5 = 7hrs and 30mins.
7.25 = 7hrs and 15mins.
Is there a formula which I can use to convert 7.5 into 07:30 ([HH]:MM)
Thanks,
Gary
I have an export which gives my days off by fraction.
Example: 7.5 = 7hrs and 30mins.
7.25 = 7hrs and 15mins.
Is there a formula which I can use to convert 7.5 into 07:30 ([HH]:MM)
Thanks,
Gary