Thanks for the help. I thought it would be that easy. After looking at the
link you gave me, it helped to know that time is based on a portion of a day
(which makes sense). What I did wrong was A1, B1 and C1 cells were all
formated as "time". When I changed the answeer (C1) to a number it worked as
expected.

Thanks again


"Jason Morin" wrote:

=(B1-A1)*24

To learn about how XL handles date/time values, see:

http://www.cpearson.com/excel/datetime.htm#AddingDates

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm trying to create an Excel time clock.

A1= Start Time (7:00)
B1= End Time (15:00)
C1= Hours for the day

What is the formula in c1 to get a result of 8

.