Help with conversion of time formula.

[Jacko1307]

Good morning
Help please in my working out.
The clocking in and out interface we have date time stamps when a worker has clocked into the site.

I pull a CSV of the complete workforce weekly and the conundrum I have is that the timestation will produce the CSV with a decimal for the MM i.e 28.63hrs. Pay is worked out on a 15 minute time period so if someone works 10.89 I need for it to round up to 11 hrs and if someone works 10.01 I need it to round down to 10.

I have worked out a simple sheet to which I apply the criteria at the end of each week to be fair to employees.

I have looked at the decimals for the minutes in an hour and have selected the following decimal criteria.


Decimal .00 to .13 round down to nearest hour

Decimal .14 to .38 round to 1/4 hr (.25)

Decimal .39 to .63 round to 1/2 hr (.50)

Decimal .64 to .88 round to 3/4hr (.75)

Decimal .89 to .99 round to next hour upwards.

Hope the above makes sense .

Thank you in anticipation

 

[Legacy 143009]

How about:

=MROUND(value, 0.25)

 

[Phuoc]

Maybe like this:

=MROUND(A1,0.25)

 

[Jacko1307]

How about:

=MROUND(value, 0.25)

Thank you so much I was very much overthinking the problem.

Works a treat Brilliant

Martin

 

[Legacy 143009]

Sometimes I do the same No worries