I have a schedule as
From To From To
7:30 AM 4:00 PM 8:00 AM 4:00 PM

What formula do I use to get the result 16.5?

Thanks

Hi

One way
=MOD(B1-A1,1)+MOD(D1-C1,1)
format the cell with the result as [h]:mm as this will allow it to sum
past 24 hours if necessary.
Using the MOD function in this way, will also deal with any cases where
end time is less than start time (e.g. from 4:00 PM today through till
8:30 AM tomorrow)

--
Regards

Roger Govier


"SUPERNAM" wrote in message
...
I have a schedule as
From To From To
7:30 AM 4:00 PM 8:00 AM 4:00 PM

What formula do I use to get the result 16.5?

Thanks

=(B2-A2)+(D2-C2)

will give 16:30. If you want it as decimal, just multiply by 24.

--

HTH

RP

"SUPERNAM" wrote in message
...
I have a schedule as
From To From To
7:30 AM 4:00 PM 8:00 AM 4:00 PM

What formula do I use to get the result 16.5?

Thanks

((4:00 PM - 7:30 AM)+(4:00 PM - 8:00 AM))*24

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"SUPERNAM" wrote:

I have a schedule as
From To From To
7:30 AM 4:00 PM 8:00 AM 4:00 PM

What formula do I use to get the result 16.5?

Thanks

Thanks very much

"Roger Govier" wrote:

Hi

One way
=MOD(B1-A1,1)+MOD(D1-C1,1)
format the cell with the result as [h]:mm as this will allow it to sum
past 24 hours if necessary.
Using the MOD function in this way, will also deal with any cases where
end time is less than start time (e.g. from 4:00 PM today through till
8:30 AM tomorrow)

--
Regards

Roger Govier


"SUPERNAM" wrote in message
...
I have a schedule as
From To From To
7:30 AM 4:00 PM 8:00 AM 4:00 PM

What formula do I use to get the result 16.5?

Thanks

Thanks

"Bob Phillips" wrote:

=(B2-A2)+(D2-C2)

will give 16:30. If you want it as decimal, just multiply by 24.

--

HTH

RP

"SUPERNAM" wrote in message
...
I have a schedule as
From To From To
7:30 AM 4:00 PM 8:00 AM 4:00 PM

What formula do I use to get the result 16.5?

Thanks

Thanks

"Gary L Brown" wrote:

((4:00 PM - 7:30 AM)+(4:00 PM - 8:00 AM))*24

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"SUPERNAM" wrote:

I have a schedule as
From To From To
7:30 AM 4:00 PM 8:00 AM 4:00 PM

What formula do I use to get the result 16.5?

Thanks