| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding time in a work schedule
adding time (30 minute lunch) to a time value (6 hours) that is calculated
from two cells that contain starting time & ending time EX 6:30am-3:00pm -- Chris |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding time in a work schedule
=A1+"00:30:00"
-- Regards Dave Hawley www.ozgrid.com "Chris" wrote in message ... adding time (30 minute lunch) to a time value (6 hours) that is calculated from two cells that contain starting time & ending time EX 6:30am-3:00pm -- Chris |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding time in a work schedule
One mo
=A1+TIME(0,30,0) Regards, Fred "ozgrid.com" wrote in message ... =A1+"00:30:00" -- Regards Dave Hawley www.ozgrid.com "Chris" wrote in message ... adding time (30 minute lunch) to a time value (6 hours) that is calculated from two cells that contain starting time & ending time EX 6:30am-3:00pm -- Chris |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding time in a work schedule
Hi Chris
With start time in cell A1 and end time in cell B1 In cell C1 apply the below formula and format the formula cell to custom format [h]:mm =(B1-A1)+(0.5/24) -- Jacob (MVP - Excel) "Chris" wrote: adding time (30 minute lunch) to a time value (6 hours) that is calculated from two cells that contain starting time & ending time EX 6:30am-3:00pm -- Chris |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding time in a work schedule
-- Thanks Jacob, but let me explain my dilema further. I have 6:30am in cell A1 & 3:00pm in cell B1; I have both of these cells formatted as custom h:mm AM/PM & I have C1 formatted as h:mm (in this cell is the total hours from A & B) I have been able to add or subtract a 30 min lunch w/formulas; my question is: can I have a formula in all affected cells(the total daily hours across a 7 day work schedule) that would add a 30 min period only to those cells that are greater than 6 hours? Chris "Jacob Skaria" wrote: Hi Chris With start time in cell A1 and end time in cell B1 In cell C1 apply the below formula and format the formula cell to custom format [h]:mm =(B1-A1)+(0.5/24) -- Jacob (MVP - Excel) "Chris" wrote: adding time (30 minute lunch) to a time value (6 hours) that is calculated from two cells that contain starting time & ending time EX 6:30am-3:00pm -- Chris |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding time in a work schedule
Try the below formula and format the cell to [h]:mm
=IF(MOD(B1,1)-MOD(A1,1)"06:00",MOD(B1,1)-MOD(A1,1)+(0.5/24), MOD(B1,1)-MOD(A1,1)) -- Jacob (MVP - Excel) "Chris" wrote: -- Thanks Jacob, but let me explain my dilema further. I have 6:30am in cell A1 & 3:00pm in cell B1; I have both of these cells formatted as custom h:mm AM/PM & I have C1 formatted as h:mm (in this cell is the total hours from A & B) I have been able to add or subtract a 30 min lunch w/formulas; my question is: can I have a formula in all affected cells(the total daily hours across a 7 day work schedule) that would add a 30 min period only to those cells that are greater than 6 hours? Chris "Jacob Skaria" wrote: Hi Chris With start time in cell A1 and end time in cell B1 In cell C1 apply the below formula and format the formula cell to custom format [h]:mm =(B1-A1)+(0.5/24) -- Jacob (MVP - Excel) "Chris" wrote: adding time (30 minute lunch) to a time value (6 hours) that is calculated from two cells that contain starting time & ending time EX 6:30am-3:00pm -- Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Graveyard Work Schedule | Excel Worksheet Functions | |||
| Work Schedule | Excel Worksheet Functions | |||
| How to write the formula for time accounting for a work schedule | Excel Worksheet Functions | |||
| How can I set up a work schedule in Excel? | Excel Discussion (Misc queries) | |||
| How to use solver to schedule part time and full time workforce? | Excel Discussion (Misc queries) | |||
Hybrid Mode
