I’m using the following in a control source on a report to express a running total in hours and minutes, even if the total is greater than 24 hours:
=Int([txtrunsum])*24+DatePart(“h”,[txtrunsum]) & “:” & DatePart(“n”,[txtrunsum])
It’s working well, but if the minute portion is less than 10 minutes, the time is displayed as 36:5, for example. The toal is 5 minutes and I would like it displayed as 36:05.
If the minutes are greater than 10 it displays correctly; 65:30, as an example.
I’m hoping for a simple adjustment, as this really works well other than the minute issue!
Thanks in advance.