Hello
To convert hours and minutes from a decimal number to the hh:mm:ss format,
use the following formula:
Use this formula to convert 11.50 minutes to 0:11:30:![]()
11.50 hours =Hours.Minutes/24 =11.5/24
Use this formula to convert 11.5 hours to 011:30:00:![]()
=11.50/1440
HTH![]()
=11.5/24
Bookmarks