Converting hours to Days / hours / mins

[BettsPaul]

How can I display a number which I have in hours to display in Days Hours and possibly minutes

 

[MJRBIM]

What format is your hours field in - number (35.75) or integer(36)?

 

[MJRBIM]

Insert the formulas below...update the {Table.HOURS} field with your own {Table.Field}

Name : {@DAYS}
Formula : Int ({Table.HOURS}/24)


Name : {@HOURS}
Formula : Int ({Table.HOURS} - (Int ({Table.HOURS}/24) * 24))


Name : {@MINUTES}
Formula : ({Table.HOURS} - Int ({Table.HOURS})) * 60

It returns data as follows...

HOURS @DAYS @HOURS @MINUTES
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
36.00 1 12 0
35.75 1 11 45
77.50 3 5 30
48.00 2 0 0
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

 

[synapsevampire]

I have a FAQ here that should help:

faq767-3543

The only significant difference being that you'd want to divide the hours by 24 to get the days.

-k