| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round current time
I have a timesheet with checkboxes. When the checkbox is checked it
automatically enters the current time into a cell. I need the time to be rounded to the nearest five minutes...I have the time format set to show as 1:30 AM but seems to read 3/28/2006 9:45:55 AM...here is the formula I have in the cell to include the current time: =IF(F18=TRUE,NOW(),"")....F18 refers to the checkbox when checked. How can i get the time to round up to the next 5 minute interval? or can I? Any help would be greatly appreaciated. I thank you in advance for your assistance! -- Randy Street Rancho Cucamonga, CA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show current date and time | New Users to Excel | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Round Up Time IF | Excel Worksheet Functions | |||
| Round UP Time | Excel Worksheet Functions | |||
Threaded Mode
