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 |
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 |