G Guest Jan 6, 2004 #1 how do i round to the nearest quarter hour (.25, .50, .75) in a payroll worksheet. i've tried the round function, but it's not returning the values i want. help...
how do i round to the nearest quarter hour (.25, .50, .75) in a payroll worksheet. i've tried the round function, but it's not returning the values i want. help...
P Paul Jan 6, 2004 #2 glenn said: how do i round to the nearest quarter hour (.25, .50, .75) in a payroll Click to expand... worksheet. i've tried the round function, but it's not returning the values i want. help... One way: =ROUND(A1*4,0)/4
glenn said: how do i round to the nearest quarter hour (.25, .50, .75) in a payroll Click to expand... worksheet. i've tried the round function, but it's not returning the values i want. help... One way: =ROUND(A1*4,0)/4
B Bob Phillips Jan 6, 2004 #3 Glenn, Paul's solution is fine for normal numbers, buts as time is held as a fraction of 1 day, you need to scale it up, and then down again =ROUND(A1*4*24,0)/4/24 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Glenn, Paul's solution is fine for normal numbers, buts as time is held as a fraction of 1 day, you need to scale it up, and then down again =ROUND(A1*4*24,0)/4/24 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
