How can I calculate hours in a Hourly schedule in Excel?
 

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

How can I calculate hours in a Hourly schedule in Excel?
 

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

How can I calculate hours in a Hourly schedule in Excel?
 

=(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

How can I calculate hours in a Hourly schedule in Excel?
 

((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

How can I calculate hours in a Hourly schedule in Excel?
 

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

How can I calculate hours in a Hourly schedule in Excel?
 

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

How can I calculate hours in a Hourly schedule in Excel?
 

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