Prev: HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B
Next: Record time by formula
From: Chris on 28 Apr 2010 21:21
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
From: ozgrid.com on 28 Apr 2010 21:26
=A1+"00:30:00"



--
Regards
Dave Hawley
www.ozgrid.com
"Chris" <Chris(a)discussions.microsoft.com> wrote in message
news:861495D5-9D4A-4965-854E-34B5E9819EE4(a)microsoft.com...
> 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

From: Fred Smith on 28 Apr 2010 22:52
One more:
=A1+TIME(0,30,0)

Regards,
Fred

"ozgrid.com" <dave(a)ozgrid.com> wrote in message
news:4E9BE2FB-64A9-4F3B-86C7-6A648D5EB531(a)microsoft.com...
> =A1+"00:30:00"
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "Chris" <Chris(a)discussions.microsoft.com> wrote in message
> news:861495D5-9D4A-4965-854E-34B5E9819EE4(a)microsoft.com...
>> 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
>

From: Jacob Skaria on 29 Apr 2010 00:57
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
From: Chris on 29 Apr 2010 18:36

-- 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
 |  Next  |  Last
Pages: 1 2
Prev: HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B
Next: Record time by formula