Days to Hours
I am trying to create a timesheet that will add up all the hours for the week. I use a formula to add the hours, but it displays it as days and hours rather than just hours, e.g. 5 days :20 rather than 40:20. How do I format it to show it in hours only? Thanks.
8 replies
-
Leo
-
Why not just populate the Time Interval field with the result of the calculation?
-
@Mconneen
How to do that, there is no formula field with Time Interval?
-
@Mconneen
How to do that, there is no formula field with Time Interval?
-
I did it on an the tables after update trigger.
-
Ok, I get it. Thanks
-
Maybe support can lead us to a format statement.. but in my few hacks.. I could not figure it out..
-
I also tried various format statements, but neither of them gave me the result I wanted.
For now, I use the update trigger as Mconneen suggested. It works.
Content aside
- 5 yrs agoLast active
- 8Replies
- 3173Views