| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
single cell time entry as time - time; Ever seen this?
Has anyone ever seen time entered as '7:00 - 9:00' in a TIME formatted cell? (It does allow the entry)
VarType returns string. vba attempts to calculate the difference directly fails - which makes sense to me. I'm guessing I'll have to isolate these values, convert and calculate elapsed time. The noon and midnight rollovers (12hr clock) is also something I have to deal with manually. Sound right?, - I've just never seen time used like this. Client insists on this format. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with calculating time and a half - I've got straight time and double time. | Excel Discussion (Misc queries) | |||
| Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
| Time entry auto changes to date and then time ? | Excel Worksheet Functions | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Userform for time entry: multiple controls/single value? | Excel Programming | |||
Threaded Mode
