| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking cells with scheduling workbook
I have an Excel workbook for scheduling employees in several departments.
Each department has their own sheet and their scheduled days/times are linked to a comprehensive sheet so all employees and their schedule are shown on one sheet. The comprehensive sheet is printed and posted to everyone. The problem I am having is that if they have a day off and the cells for the starting and ending time is blank on the ind. department sheet, the cells display 12:00 AM on the comprehensive sheet. How do I program so that whenever an employee is not scheduled, that day is blank for their starting and ending time on the comprehensive sheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking cells with scheduling workbook
Awesome! "" is what I was looking for. Thank you!!
"Ashish Mathur" wrote: Hi, Try this =if(and(A3="",D3=""),"",D3-A3) D3 holds ending time and A3 holds starting time -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "MattSwift" wrote in message ... I have an Excel workbook for scheduling employees in several departments. Each department has their own sheet and their scheduled days/times are linked to a comprehensive sheet so all employees and their schedule are shown on one sheet. The comprehensive sheet is printed and posted to everyone. The problem I am having is that if they have a day off and the cells for the starting and ending time is blank on the ind. department sheet, the cells display 12:00 AM on the comprehensive sheet. How do I program so that whenever an employee is not scheduled, that day is blank for their starting and ending time on the comprehensive sheet? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking cells with scheduling workbook
You are welcome
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "MattSwift" wrote in message ... Awesome! "" is what I was looking for. Thank you!! "Ashish Mathur" wrote: Hi, Try this =if(and(A3="",D3=""),"",D3-A3) D3 holds ending time and A3 holds starting time -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "MattSwift" wrote in message ... I have an Excel workbook for scheduling employees in several departments. Each department has their own sheet and their scheduled days/times are linked to a comprehensive sheet so all employees and their schedule are shown on one sheet. The comprehensive sheet is printed and posted to everyone. The problem I am having is that if they have a day off and the cells for the starting and ending time is blank on the ind. department sheet, the cells display 12:00 AM on the comprehensive sheet. How do I program so that whenever an employee is not scheduled, that day is blank for their starting and ending time on the comprehensive sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking cells to other sheets within a workbook | Excel Discussion (Misc queries) | |||
| Linking different cells from one sheet to another in same workbook | Excel Discussion (Misc queries) | |||
| linking cells to another workbook | Excel Worksheet Functions | |||
| Scheduling workbook | New Users to Excel | |||
| workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
