Shift Information
How can I write a formula to display shift(1,2,3) in shift column by given
time? Time Shift 08:12:10 ? 15:30:15 ? 23:55:02 ? Condition Shift 1 is time = '07:00' AND time < '15:00' Shift 2 is time = '15:00' AND time < '23:00' Shift 3 is time = '23:00' AND time < '07:00' Regards, Tee |
Shift Information
See response in public.excel
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "engteng" wrote in message ... How can I write a formula to display shift(1,2,3) in shift column by given time? Time Shift 08:12:10 ? 15:30:15 ? 23:55:02 ? Condition Shift 1 is time = '07:00' AND time < '15:00' Shift 2 is time = '15:00' AND time < '23:00' Shift 3 is time = '23:00' AND time < '07:00' Regards, Tee |
All times are GMT +1. The time now is 12:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com