Calculate time in a cell
 

I have a spread sheet that I keep the employees schedule in. What I'm trying
to do is let excel keep a tally of total hours for me.
A13 Has Carol B13 has 5:30-14:30 <~~ which are her hours for that day.
then C13, D13, E13, F13 etc etc has her schedule input the same way. (24
hour clock) In addition to keeping a tally of total hours, can it also
subtract 30 minutes per day for a lunch break?

I've tried all I know and nothing works.

Thanks in advance!

Calculate time in a cell
 

Do the subtraction and then multiply by 24.

"TiaB" wrote in message
...
I have a spread sheet that I keep the employees schedule in. What I'm
trying
to do is let excel keep a tally of total hours for me.
A13 Has Carol B13 has 5:30-14:30 <~~ which are her hours for that day.
then C13, D13, E13, F13 etc etc has her schedule input the same way. (24
hour clock) In addition to keeping a tally of total hours, can it also
subtract 30 minutes per day for a lunch break?

I've tried all I know and nothing works.

Thanks in advance!

Calculate time in a cell
 

You'll find it a lot easier if you put starting time in one cell (say
cell B2) and ending time in another (cell B3). Otherwise, you'll have
to write fancy formulas to pull out the values before you can do any
computations.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=492930

Calculate time in a cell
 

Thanks Barb!

I guess I don't understand... Cell B13 has the following in it:
5:30-14:30... I'm not sure how to write that formula??



"Barb Reinhardt" wrote:

Do the subtraction and then multiply by 24.

"TiaB" wrote in message
...
I have a spread sheet that I keep the employees schedule in. What I'm
trying
to do is let excel keep a tally of total hours for me.
A13 Has Carol B13 has 5:30-14:30 <~~ which are her hours for that day.
then C13, D13, E13, F13 etc etc has her schedule input the same way. (24
hour clock) In addition to keeping a tally of total hours, can it also
subtract 30 minutes per day for a lunch break?

I've tried all I know and nothing works.

Thanks in advance!

Calculate time in a cell
 

No offense but that is not a good design, always put numeric in single
cells, it can be done using formulas that will parse the values then do the
calculations but I'd suggest you change the layout and put 5:30 in one cell
14:30 in another
then use

=(B1-A1)*24-0.5

where A1 holds the 5:30 and B1 14:30, 0.5 is the 30 minutes in decimal time

otherwise you need something like

=(MID(A1,FIND("-",A1)+1,255)-LEFT(A1,FIND("-",A1)-1))*24-0.5

with 5:30-14:30 in A1

--
Regards,

Peo Sjoblom

(No private emails please)


"TiaB" wrote in message
...
Thanks Barb!

I guess I don't understand... Cell B13 has the following in it:
5:30-14:30... I'm not sure how to write that formula??



"Barb Reinhardt" wrote:

Do the subtraction and then multiply by 24.

"TiaB" wrote in message
...
I have a spread sheet that I keep the employees schedule in. What I'm
trying
to do is let excel keep a tally of total hours for me.
A13 Has Carol B13 has 5:30-14:30 <~~ which are her hours for that day.
then C13, D13, E13, F13 etc etc has her schedule input the same way.
(24
hour clock) In addition to keeping a tally of total hours, can it also
subtract 30 minutes per day for a lunch break?

I've tried all I know and nothing works.

Thanks in advance!