XLS Work Schedule Formulas

I have a work schedule which gives me reference numbers which relates to the time I have to work.

e.g. REF NO 540 means I have to work 06.35 - 19.20.

If I type 540 in cell B5, I would like 06.35 - 19.20 to automatically appear in cell B6 below.

e.g. REF NO 541 means I have to work 05.35 - 14.30.

If I type 541 in cell C5, I would like 05.35 - 14.30 to automatically appear in cell C6 below.

Hopefully all should become apparent in the enclosed spreadsheet.

Taidot: Excel

Näytä lisää: schedule xls, work reference, work schedule, excel type work, xls formulas, 2013 excel schedule, work schedule excel, excel time schedule, time schedule, schedule excel, excel schedule, formulas spreadsheet, xls spreadsheet j2me, spreadsheet formulas, schedule time, ref excel, pmp work experience spreadsheet, outsourcing work excel spreadsheet, hows work xls joomla, formulas excel spreadsheet, excel spreadsheet formulas, description work completed spreadsheet, shift work roster spreadsheet, xls spreadsheet template price update, work performed spreadsheet

Tietoa työnantajasta:
( 157 arvostelua ) Bridgwater, United Kingdom

Projektin tunnus: #4264265

Myönnetty käyttäjälle:


You need a VLOOKUP to do this. Regards, Svet.

$50 USD 0 päivässä
(46 Arvostelua)

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


ready to go

$30 USD 1 päivässä
(0 arvostelua)

Hi there, Please check my private message and get back to me. I look forward to hearing from you soon. Thanks. Wickrasoft

$30 USD 5 päivässä
(0 arvostelua)