Using mod 60 - add a zero under 10 minutes?

[Hfnet]

I am using the following query to get hours and minutes elapsed:

TimeOnBench \ 60 & ":" & TimeOnBench Mod 60

If a job has been going for 62 minutes it produces the result:

1:2

How can I add to the query to make anything under 10 hours or 10 minutes appear as 0x:0x, i/e 62 minutes produces 01:02?

Thanks

 

[earthandfire]

Try:

Format(TimeOnBench \ 60,"00") & ":" & Format(TimeOnBench Mod 60,"00")


Hope this helps

 

[PHV]

Another way:
Format(TimeOnBench / 1440, 'hh:nn')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Hfnet]

Thanks both of you, I went with PHV purely for length of code.