Time Clock
 

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

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

.

Jim, =A2-A1 ??
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jimcrushes" wrote in 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

This is a formula I pulled off an old Time Sheet from where I use to work.
It has 6 columns of (B,C,D,E,F & G) Time In / Time Out / TIme In / Time Out
/ Time In / Time Out and had the day of the week in Col A
formula is:

=((C5-B5+0.5)*2-TRUNC((C5-B5+0.5)*2)+(E5-D5+0.5)*2-TRUNC((E5-D5+0.5)*2)+(G5-F5+0.5)*2)-TRUNC((G5-F5+0.5)*2))*12

Hope it works for you.

I got this one here in 1999 and have forgotten who actually gave it to me.

=(end time-start time+(end time<start time))-(end time-start time+(end
time<start time))

On my spread sheet the times are listed as: starting time, lunch start,
lunch end, end time from cells D2:G2. =(G2-D2+(G2<D2))-(F2-E2+(F2<E2))
Phil


"kamille824" wrote in message
lkaboutsoftware.com...
This is a formula I pulled off an old Time Sheet from where I use to work.
It has 6 columns of (B,C,D,E,F & G) Time In / Time Out / TIme In / Time
Out
/ Time In / Time Out and had the day of the week in Col A
formula is:

=((C5-B5+0.5)*2-TRUNC((C5-B5+0.5)*2)+(E5-D5+0.5)*2-TRUNC((E5-D5+0.5)*2)+(G5-F5+0.5)*2)-TRUNC((G5-F5+0.5)*2))*12

Hope it works for you.

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

.