Forum Discussion
MCFNeil
9 years agoQrew Captain
>So, the 97 minutes would add 1 hour to the hours column and the minutes would decrease to 37.<
If you need to separate them out you can have an 2 formula numeric fields for hours and minutes, with the following equations respectively:
If you want that to display as "x hours" and "y minutes" you can make them formula text fields and change the formula to these respectively:
If you need to separate them out you can have an 2 formula numeric fields for hours and minutes, with the following equations respectively:
Int(ToHours([End Date / Time]-[Start Date / Time]))
(Rem(ToHours([End Date / Time]-[Start Date / Time]), 1)*60)
If you want that to display as "x hours" and "y minutes" you can make them formula text fields and change the formula to these respectively:
ToText(Int(ToHours([End Date / Time]-[Start Date / Time])))&" hours"
ToText((Rem(ToHours([End Date / Time]-[Start Date / Time]), 1)*60))&" minutes"