How do I convert time to the nearest 1/4 hour with a 7 min. window
 

I am creating a timesheet that totals daily as total hours/ minutes worked
(4:06). We round to the quarter hour (up or down) based on the 7 minute
window.
4:01 to 4:07 would be paid 4 hrs. - 4:08 to 4:15 would be paid 4 hrs. 15
mins..

Can EXCEL do this or will I have to calc. manually?

THANKS

How do I convert time to the nearest 1/4 hour with a 7 min. window
 

Of course it can - Excel can do anything <bg

=ROUND(A1*96,0)/96

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bigbus" wrote in message
...
I am creating a timesheet that totals daily as total hours/ minutes worked
(4:06). We round to the quarter hour (up or down) based on the 7 minute
window.
4:01 to 4:07 would be paid 4 hrs. - 4:08 to 4:15 would be paid 4 hrs. 15
mins..

Can EXCEL do this or will I have to calc. manually?

THANKS

How do I convert time to the nearest 1/4 hour with a 7 min. window
 

On Mon, 28 Aug 2006 04:32:02 -0700, Bigbus
wrote:

I am creating a timesheet that totals daily as total hours/ minutes worked
(4:06). We round to the quarter hour (up or down) based on the 7 minute
window.
4:01 to 4:07 would be paid 4 hrs. - 4:08 to 4:15 would be paid 4 hrs. 15
mins..

Can EXCEL do this or will I have to calc. manually?

THANKS


To round a time to the nearest 15 minutes, you can use this formula:

=ROUND(A1/TIME(0,15,0),0)*TIME(0,15,0)

The time is entered (or calculated) as hh:mm in A1
--ron

How do I convert time to the nearest 1/4 hour with a 7 min. wi
 

Thanks! That worked....Do I dare ask another ????
Where do I find what formulas to use (=round,=average, etc.) so I can play
and figure things out.

Since I cant take a class this morning (Except bring schooled by "Bob")....
I now have the rounded total
8/24 7:45 (plus extra hrs.) 3:25 = WHAT IS THE FORULA to make it equaL for
the day and then for the entire payperiod?

THANKS to ALL!!!







"Bob Phillips" wrote:

Of course it can - Excel can do anything <bg

=ROUND(A1*96,0)/96

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bigbus" wrote in message
...
I am creating a timesheet that totals daily as total hours/ minutes worked
(4:06). We round to the quarter hour (up or down) based on the 7 minute
window.
4:01 to 4:07 would be paid 4 hrs. - 4:08 to 4:15 would be paid 4 hrs. 15
mins..

Can EXCEL do this or will I have to calc. manually?

THANKS

How do I convert time to the nearest 1/4 hour with a 7 min. window
 

THANKS EVERYONE MY TIMESHEET IS COMPLETE!

"Bigbus" wrote:

I am creating a timesheet that totals daily as total hours/ minutes worked
(4:06). We round to the quarter hour (up or down) based on the 7 minute
window.
4:01 to 4:07 would be paid 4 hrs. - 4:08 to 4:15 would be paid 4 hrs. 15
mins..

Can EXCEL do this or will I have to calc. manually?

THANKS