Time Sheet Function

[beone2]

I'm looking for a way to calculate my clock in and out time to tenths of an hour. Actually to round(not sure which way) my clock ins and outs. Where A1 would represent my clock in time say 6:47a and A2 would represent clock out at 3:14p, column A formatted for time h:mm. What I want to know is how many tenths am I actually being paid for since my timeworked is recorded in tenths.

[VBA Noob]

See if link helps. Look under

Rounding Times

http://www.cpearson.com/excel/datearith.htm

VBA Noob

[Special-K]

If A1 = start time and B1 = end time and C1 = B1 - A1

then

=INT(C1/0.041666*60/6)

will give you the number of tenths you are being paid.

[daddylonglegs]

Do you want to round the start and end times to the nearest tenth of an hour and calculate the difference, or calculate the difference then round it?..... there's a difference.

If it's the latter and you want the result as a decimal, i.e. 8.5 for your example use the formula

=ROUND((A2-A1)*24,1)

If you need to accommodate shifts which start one day and end the next, e.g. 22:00 to 06:00 then change to

=ROUND(MOD(A2-A1,1)*24,1)