Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula is counting cell if nothing is entered
I have made a timesheet that will automatically round up to the nearest
quarter hour, but if no time is entered the round column stays as 12:00 am and calcualtes as such. The first col. has the actual time then the second col. has the formula =round(E12*24/0.25,0)*0.25/24 which works to round the time, but, as I said, if nothing is entered in the time, the round col. shows 12:00 am. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula is counting cell if nothing is entered
Hi
Try one of the following modifications to your formula: =IF(E12="","",ROUND(E12*24/0.25,0)*0.25/24) =IF(ISBLANK(E12),"",ROUND(E12*24/0.25,0)*0.25/24) Regards, B. R. Ramachandran "Jennifer" wrote: I have made a timesheet that will automatically round up to the nearest quarter hour, but if no time is entered the round column stays as 12:00 am and calcualtes as such. The first col. has the actual time then the second col. has the formula =round(E12*24/0.25,0)*0.25/24 which works to round the time, but, as I said, if nothing is entered in the time, the round col. shows 12:00 am. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula is counting cell if nothing is entered
I have tried both of those before and it comes back with a "Incorrect time
format" box and indicates to cancel or retry... "B. R.Ramachandran" wrote: Hi Try one of the following modifications to your formula: =IF(E12="","",ROUND(E12*24/0.25,0)*0.25/24) =IF(ISBLANK(E12),"",ROUND(E12*24/0.25,0)*0.25/24) Regards, B. R. Ramachandran "Jennifer" wrote: I have made a timesheet that will automatically round up to the nearest quarter hour, but if no time is entered the round column stays as 12:00 am and calcualtes as such. The first col. has the actual time then the second col. has the formula =round(E12*24/0.25,0)*0.25/24 which works to round the time, but, as I said, if nothing is entered in the time, the round col. shows 12:00 am. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula is counting cell if nothing is entered
Jennifer
Trap the error in your formula. =IF(E12="","",ROUND(E12*24/0.25,0)*0.25/24) If E12 is blank then nothing, otherwise do the calculation. Gord Dibben Excel MVP On Wed, 14 Dec 2005 12:16:39 -0800, "Jennifer" wrote: I have made a timesheet that will automatically round up to the nearest quarter hour, but if no time is entered the round column stays as 12:00 am and calcualtes as such. The first col. has the actual time then the second col. has the formula =round(E12*24/0.25,0)*0.25/24 which works to round the time, but, as I said, if nothing is entered in the time, the round col. shows 12:00 am. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula is counting cell if nothing is entered
Hi,
I did try out the formulas before suggesting them to you. They do work. Make sure that the cell(s) containing the formula is(are) formatted for "Time" as "1:30 PM". Regards, B. R. Ramachandran "Jennifer" wrote: I have tried both of those before and it comes back with a "Incorrect time format" box and indicates to cancel or retry... "B. R.Ramachandran" wrote: Hi Try one of the following modifications to your formula: =IF(E12="","",ROUND(E12*24/0.25,0)*0.25/24) =IF(ISBLANK(E12),"",ROUND(E12*24/0.25,0)*0.25/24) Regards, B. R. Ramachandran "Jennifer" wrote: I have made a timesheet that will automatically round up to the nearest quarter hour, but if no time is entered the round column stays as 12:00 am and calcualtes as such. The first col. has the actual time then the second col. has the formula =round(E12*24/0.25,0)*0.25/24 which works to round the time, but, as I said, if nothing is entered in the time, the round col. shows 12:00 am. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
formula for counting charachters in a cell ? | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions |