Have done more tests and discovered things are not as close as I thought they were when I put in a 30 minute AND it comes out wrong what I have done of course the void maximum minutes divided by 60
So there must be a more accurate way to do this hope someone out there can help

I have done some more work on this problem and I have worked out as coming out at a fraction of an hour not minutes as I thought it was if anyone want me to send the query and form to them as I can build the information themselves and a safe database please contact me I can send the query to you is photos as you are able to duplicate the query

Don't work with fractions of an hour. Figure out the total minutes per record. Add those up. Now you've got a number like 150 minutes. Integer divide by 60 to get 2 hours. Subtract the difference to get 30 minutes remaining.

Access Expert 8 (which you have) has an employee work log very similar to this.

sending u a email

Please don't. My inbox is overflowing. As I've explained numerous times... if you need tech support, you can post here in the Forums or use my Tech Support page. I don't have time to answer a million questions when I have already covered this stuff in my videos.

I would make an unbound field called TotalMinutes on your form, and put this in it assuming your SUM fields are called HoursWorked and MinutesWorked.

=(HoursWorked*60)+MinutesWorked

Thatll give you the total minutes.
Then I'd make another unbound field and put this in it

=[TotalMinutes]\60 & Format([TotalMinutes] Mod 60,"\:00")

On your screenshot, this would return 72:27 (72 hours and 27minutes total)

If you just want to round your own sum field, just use the round function, do something like =Round(Sum([MinutesWorked]/60),1) to round to 1 decimal or 0 to round to 0.

Alternatively you can just do \60 instead of /60 to round to integer.

Here you go: Timesheets

Thanks