How do you calculate hours?
 

My schedule is broken down into days-
example 6:00 a.m.-2:30p.m. monday thru sunday. Is there a
formula for calculating the total number of hours automatically.

How do you calculate hours?
 

A bit more information may have been useful but to get you started try this
a1 = 06:00
b1 = 14:30
Both these times can be formatted as you require
Then in another cell try
=(B1-A1)*6
Format this cell with [hh]:mm
This will give you the hours for 6 days 06:00 - 14:30

Mike


"chefd" wrote:

My schedule is broken down into days-
example 6:00 a.m.-2:30p.m. monday thru sunday. Is there a
formula for calculating the total number of hours automatically.

How do you calculate hours?
 

As Excel stores times as a fraction of a day, to convert to hours, multiply
by 24. If endtime is in B1 and starttime is in A1, then hours worked would
be:

=(b1-a1)*24

Regards,
Fred.

"chefd" wrote in message
...
My schedule is broken down into days-
example 6:00 a.m.-2:30p.m. monday thru sunday. Is there a
formula for calculating the total number of hours automatically.