Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Calculation
Hi All,
I have a sheet to track the breaks of the team. in the last column i have total break that is (In time - Out time). now when a person enters Out time the total beak shows ###### because In Time is still not there. I tried ISERROR but it didnt work. any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Calculation
Not sure if this is what you are after:
You could Conditionally Format the cells with the Sign function Example: Formula is =SIGN(C1)= -1 (Where C1 is your last column and the first row of subtraction results) Then Format the cells with a solid black pattern Instead of ########## you get a solid black cell... Not sure if one is better than the other. Just a suggestion. "Gary" wrote in message ... Hi All, I have a sheet to track the breaks of the team. in the last column i have total break that is (In time - Out time). now when a person enters Out time the total beak shows ###### because In Time is still not there. I tried ISERROR but it didnt work. any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Calculation
If(Or(InTime="",OutTime=""),"",OutTime-InTime)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gary" wrote in message ... Hi All, I have a sheet to track the breaks of the team. in the last column i have total break that is (In time - Out time). now when a person enters Out time the total beak shows ###### because In Time is still not there. I tried ISERROR but it didnt work. any ideas? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Calculation
Yeah Bob.....Thats It.
Thats why am a fan of urs. Thanks a ton. "Bob Phillips" wrote in message ... If(Or(InTime="",OutTime=""),"",OutTime-InTime) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gary" wrote in message ... Hi All, I have a sheet to track the breaks of the team. in the last column i have total break that is (In time - Out time). now when a person enters Out time the total beak shows ###### because In Time is still not there. I tried ISERROR but it didnt work. any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheet Calculation | Excel Discussion (Misc queries) | |||
#VALUE! in Time Calculation | Excel Worksheet Functions | |||
perform calculation only if current time is after 10 am | Excel Worksheet Functions | |||
"Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
time calculation excel | Excel Worksheet Functions |