How do you calculate hours?

[chefd]

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.

 

[Mike H]

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

 

[Fred Smith]

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.