topic Re: Convert Hour to minutes in App Development

Convert Hour to minutes

CHRIS_Singa — Fri, 28 Mar 2025 13:41:51 GMT

Hello

I would like to convert hours to minutes.

How can I make this with qlik Sense (Back-end script) ?

Can someone help with this issue please ?

Thank you in advance

Re: Convert Hour to minutes

nhenckel — Fri, 28 Mar 2025 16:50:40 GMT

You can calculate minutes by simply multiplying your hour field by 60 in the script. For example:

Working_Hour * 60 AS [Expected minutes]

Here’s a sample script showing how it works:

LOAD 
    Ticket,
    Working_Hour,
    Working_Hour * 60 AS [Expected minutes]
INLINE [
    Ticket, Working_Hour
    1, 160.56
    2, 20.3
    3, 53.32
    4, 10.5
    5, 25.1
];

This will give you the minutes based on your hour values.

Re: Convert Hour to minutes

CHRIS_Singa — Mon, 31 Mar 2025 07:49:47 GMT

Thank you for the feedback.

What can I do if iwant to view as : 9633 minutes and ..... secondes

Do you have any suggestion ?

Re: Convert Hour to minutes

Chanty4u — Mon, 31 Mar 2025 18:33:53 GMT

You can modify above script

LOAD

Ticket,

Working_Hour,

Floor(Working_Hour * 60) AS [Minutes], // Extract Whole Minutes

Round((Working_Hour * 60 - Floor(Working_Hour * 60)) * 60) AS [Seconds], // Extract Remaining Seconds

Floor(Working_Hour * 60) & ' minutes and ' & Round((Working_Hour * 60 - Floor(Working_Hour * 60)) * 60) & ' seconds' AS [Formatted Time]

INLINE [

Ticket, Working_Hour

1, 160.56

2, 20.3

3, 53.32

4, 10.5

5, 25.1

];

Re: Convert Hour to minutes

MarcoWedel — Wed, 11 Jun 2025 20:40:30 GMT

although this question already has a solution I just wanted to propose this one as well:

table1:
LOAD Ticket,
WorkingHour,
Dual(Replace(Interval(WorkingHour/24,'mm:ss'),':',' minutes and ')&' seconds',WorkingHour/24) as ExpectedMinutes
Inline [
Ticket, WorkingHour
1,160.56
2,20.3
3,53.32
4,10.5
5,25.1
];

Re: Convert Hour to minutes

CHRIS_Singa — Fri, 13 Jun 2025 08:50:11 GMT

Thank you for the propose.

This is an easy way to deal with that case as well

Re: Convert Hour to minutes

MarcoWedel — Mon, 30 Jun 2025 21:13:40 GMT

glad you liked it