Forms Ver 11.0
I have a simple time sheet that is calculating the number of hours worked for each day of the week. And then gives the total hours for the entire week. I'm needing to convert the Weekly Total field to a time format of HH:MM instead of a decimal result. i.e 15.3 Hrs. Is there a built in function I'm missing, or perhaps something in javascript?
Question
Question
time calculations
asked on November 25
0
0
Answers
APPROVED ANSWER
replied on November 26
I'm assuming your Total Hours field is a text field in which case the following formula (replace the variable) should work for you:
Floor just grabs the integer portion of the total as hours
Mod(Num#, 1) grabs the decimal portion of the total which multiplied by 60 gets you your minutes
=CONCATENATE( FLOOR(SUM(My_Table.Daily_Tot)), ":", MULT( MOD(SUM(My_Table.Daily_Tot), 1), 60 ) )
1
0
SELECTED ANSWER
replied on November 26
Thanks again. worked like a charm!
2
0
Replies
You are not allowed to reply in this post.
You are not allowed to follow up in this post.