| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert an elapsed time in minutes to Days hours and minute | Excel Discussion (Misc queries) | |||
| making a time a measurement of time, not an hour of the day?? | Excel Discussion (Misc queries) | |||
| Time calculations and additional 24 hour days | Excel Worksheet Functions | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Linear Mode
