Posted to microsoft.public.excel.misc
|
|
Calculate time
Thanks.
"Jman" wrote in message
...
Try this one.
http://www.savefile.com/files/1795669
"Jill Johnson" wrote:
I typed the command and nothing happened. The new cell displays the
formula
and did not give me the result. Do you have any suggestions?
Thanks.
"Peo Sjoblom" wrote in message
...
This will give you the time for John Doe
=SUMPRODUCT(--(C3:C14="Stop"),--(D3:D14="John
Doe"),B3:B14)-SUMPRODUCT(--(C3:C14="Start"),--(D3:D14="John
Doe"),B3:B14)
Where B3:B14 are the times, C3:C14 are the status and D3:D14 are the
employees
format as hh:mm:ss
--
Regards,
Peo Sjoblom
"Jill Johnson" wrote in message
...
Thanks for your prompt response.
If the start time and end time are in rows, what would you do? For
example,
John Doe clocks in at 7:58 am and clocks out at 4:35 pm. The file
has a
Start and Stop time mixed together depending on when the employee
clocks
in
and out. Thanks.
Date Start/Stop Time Status Employee
9/17/08 6:35 am Start John Doe
9/17/08 6:41 am Start Allan Sheep
9/17/08 6:42 am Stop Steve Palmer
9/17/08 6:42 am Start Robert Conelly
9/17/08 4:35 pm Stop John Doe
9/17/08 4:36 pm Start Joseph Smith
9/17/08 4:37 pm Stop Robert Conelly
9/17/08 4:39 pm Stop Allan Sheep
9/17/08 4:45 pm Start Art Miller
9/17/08 4:48 pm Stop Joseph Smith
"Peo Sjoblom" wrote in message
...
=B1-A1
format as hh:mm:ss
where B1 is end and A1 start
if there can be more than 24 hours use
[h]:mm:ss
as a format
--
Regards,
Peo Sjoblom
"Jill Johnson" wrote in message
...
Is there a way to calculate the time quickly in Excel 2007? For
example,
the employee clocks in 7:58 am and clocks out at 4:35 pm. I want
to
know
how many hours, minutes, and seconds between 7:58 am and 4:35 pm.
Thanks.
|