Show Numeric Formula Field as Duration
I am creating a time tracking application. Need to allow for entering actual hours and for the use of a clock in/out option. Here is the set up:
Time Entries - table to track/enter specific work tasks performed for each Project. Time worked can either be entered directly into an Hours Worked (numeric field) or it will calculate Total Time (duration summary field).
Time In/Out - table to clock in/out for a specific Time Entry. All in/out entries are summarized into the Total Time field in Time Entries.
My Time Time Entries table has a field Hours Billed which displays either the Hours Worked or the Total Time. All these fields are visible on the Time Entries form but since they are of different types, they display differently.
Example, if the time entry is for 30 min the:
Hours Worked (numeric) displays as 0.50
Total Time (duration) displays as 0:30
Hours Billed (numeric) displays as 0.50
How can I get Hours Worked and Hours Billed to display like Total Time?