Formulas

[jwm1346]

I need help with creating a formula to add 7 different cells. I a
making a scheduling template and need it to be able to recognize th
am/pm clock, not the 24 hour clock. Also, in each day, if the shif
worked is more than 5 hours, it needs to take off 30 mintues from tha
shift. The sum needs to be added in a final, single cell. Can you hel
me

 

[Frank Kabel]

Hi
if you enter for each day in column A the starting time and in column B
the ending time enter the following in column C:
=B1-C1-(B1-C1>5/24)*(1/48)
format this cell as time and copy down for all rows
Note: The time format is not relevant for the calculation. Excel
internally stores times as numbers (1 hour = 1/24)

At the end of these rows enter the following formula (lets say in C8)
as total
=SUM(C1:C7)
format this cell with the custom format [hh]:mm (goto 'format - Cells'
to do this).

Also take a look at
http://www.cpearson.com/excel/datetime.htm
for more information about dates/times