Time Clock and converting to 3 min increment

[concretetsunami]

Okay I have a basic Time clock calculation in excel (i.e.-(timeout1-timein1)+(timeout2-timein2)="Total time"). What I need to do is convert the "Total time" to be changed to 3 min increments. I don't know if that is the best way to put it but let me show you the chart for the conversions.
3 mins=.05 hrs, 6 mins=.10, etc etc etc.
So lets put this into us
A1 (timein1)= 6:42 AM
A2(timeout1)=11:30 AM
A3(timein2)= 12:00 PM
A4(timeout2)= 5:00 PM (17:00)

So A5(Total Time)=9h 48min, but I need it to equal 9.80 hrs because with the conversion, 48 mins is .80 of an hour. So how can I set up A5 (Total time) to automatically do this calculation? This website is how I would like it to work http://www.1728.com/timecard.htm Thanks in advance.

[Paul]

Hi Concrete,

Perhaps try the formula

=24*((A2-A1)+(A4-A3))

[concretetsunami]

That didn't work. Sorry.

[Paul]

That didn't work. Sorry.

That response doesn't help us help you at all.

What about it didn't work? Are you getting an error? Unexpected results? Be a little more descriptive..

When I enter valid times in A1, A2, A3 and A4, it works just fine in my worksheet.

[daddylonglegs]

That didn't work. Sorry.

It would be more helpful if you could explain how.

I used Paul's formula with your data and I got the required result 9.8, what did you get?

You say you want to use 3 minute increments but you also say it should work as per the website you linked to. That website doesn't use 3 minute increments, so which is it?

[concretetsunami]

Maybe I don't have it in the correct format. How do you have A5 formatted?

[Paul]

As a number with two decimal places

[concretetsunami]

You say you want to use 3 minute increments but you also say it should work as per the website you linked to. That website doesn't use 3 minute increments, so which is it?

I know I have to round to the nearest tenth when using that website. I am sorry for not explaining what didn't work.

[concretetsunami]

thank you so much. That was the problem. I had the cell formatted wrong. Thanks again.