3 Replies Latest reply on Dec 8, 2016 8:18 AM by paolo.raia

# Converting decimal time to hours and minutes

Hi,

I have decimal time that I wish to convert to hours/minutes.  For example, 1.5 should read as 1hr 30mins.  Example table, below:-

I started to create a function calculation involving STR(INT(FIND(MID etc etc, then wondered if there was a simpler approach.

• ###### 1. Re: Converting decimal time to hours and minutes

Hi Paolo,

Check the following thread concerning conversion decimal > hours, minutes

1 of 1 people found this helpful
• ###### 2. Re: Converting decimal time to hours and minutes

Hey Paolo,

I had a do this in a few separate steps:

1. Convert decimals to minutes

2. Calculate number of hours

3. Calculate number of minutes (taking into account the number of hours)

4. Combine the fields into your desired formatting:

Final product:

Hope this helps!

Walt

1 of 1 people found this helpful
• ###### 3. Re: Converting decimal time to hours and minutes

Thank you both Norbert and Walt for your replies.  Very insightful indeed.