Formatting times when hours is greater than 24

[PeterCol]

I want to add a column of hours and minutes to give a result in hours and minutes so that if the total was 123 hrs and 30 mins it would display as 123:30. Excel allows this but I can't find a way of doing this in access - the maximum hours allowed seems to be 24. Is there a work around?

Thanks

 

[imspartacus]

You could read the left 2 characters (hours) of all the times with
left(time_variable,2)
and then add the numbers you get.
You could then add all the right hand (minute) characters of all the times using
right(tim_variable).

Then calculate the number of hours that your minutes total is (trivial) and the remainder. Add the total to your previous hours total and you should be able to combine the 2 totals to make a new totals time.

 

[PeterCol]

I can get the same result by multiplying by 24, however that does not leave me with hrs and minuts and formatting the number brings me back to the original problem.

 

[bat17]

I think that you will have to build a function to display the format for you.

=int(MyHours*24) & ":" & int(((MyHours*24) - int(MyHours*24))*60)


I have not tested this formula and you may need to combine the Format fuction as well!

Peter

 

[PeterCol]

That will work. I had just hoped there was an inbuilt format that I was not aware of.

Thanks