Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore Text when calculating time
I am trying to get a time sheet (schedule) to work that will calculate mil
time. I am able to calculate the time nicely but, is there a way to ignore text that may end up in a cell. Such as SICK or HOL. The string I am currently use to add up time entered in mil time and convert to hours worked follows. =(B5C5)+-C5-B5 I simply need a function that will ignore text entered. Is this making sense:) Thanks in advance Dale |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ignore Text when calculating time
So you are only checking 2 cells? If so
=IF(COUNT(B5:C5)=2,(B5C5)+C5-B5,"") -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "DaleP1" wrote in message ... I am trying to get a time sheet (schedule) to work that will calculate mil time. I am able to calculate the time nicely but, is there a way to ignore text that may end up in a cell. Such as SICK or HOL. The string I am currently use to add up time entered in mil time and convert to hours worked follows. =(B5C5)+-C5-B5 I simply need a function that will ignore text entered. Is this making sense:) Thanks in advance Dale |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with calculating time | Excel Discussion (Misc queries) | |||
Converting Text to Time format of XX:XX | Excel Discussion (Misc queries) | |||
Calculating elapsed time | Excel Worksheet Functions | |||
Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |