Hours Worked

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

I have set up a spreadsheet so that I input the time someone starts work and
the time they finish. In the next column, I had set it so that it
automatically works out how many hours they have worked:-

ie. A B C (cell formated as customer
hh:mm)
10:00 14:00 4:00


I am doing this on a daily basis. At the bottom of the spread sheet I would
like it to automatically work out the total ammount of hours worked
throughtout that period. I tried =SUM C2:C30 however it didn't come back
with a normal figure, but something like 3:50.

Any ideas what function I should use to work out total number of hours
worked in column C? Also how should I format cell?

Thanks
 
Hi
just change the format of your target cell to the custom format
[hh]:mm
to prevent the rollover after 24 hours
 
Frank Kabel said:
Hi
just change the format of your target cell to the custom format
[hh]:mm
to prevent the rollover after 24 hours
Click to expand...

So that's how you manage to post 500 some solutions every day -it's the same
day !

Best wishes Harald
 
Harald said:
Frank Kabel said:
Hi
just change the format of your target cell to the custom format
[hh]:mm
to prevent the rollover after 24 hours
Click to expand...

So that's how you manage to post 500 some solutions every day -it's
the same day !

Best wishes Harald
Click to expand...

lol

best regards
Frank
 
Thanks for your help all!

Thanks again to Frank Kabel who has answered two of my queries now! Sorry if
these questions have already been asked, as I know how frustrating it can be
to answer the same query over and over again!

Thanks again all

PS: My spreadsheet is looking excellent now!

Leo Heuser said:
If you format the cell with the custom format
[hh]:mm
it should come out right.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

That's Confidential said:
I have set up a spreadsheet so that I input the time someone starts work and
the time they finish. In the next column, I had set it so that it
automatically works out how many hours they have worked:-

ie. A B C (cell formated as customer
hh:mm)
10:00 14:00 4:00


I am doing this on a daily basis. At the bottom of the spread sheet I would
like it to automatically work out the total ammount of hours worked
throughtout that period. I tried =SUM C2:C30 however it didn't come back
with a normal figure, but something like 3:50.

Any ideas what function I should use to work out total number of hours
worked in column C? Also how should I format cell?

Thanks
Click to expand...
Click to expand...
 
Back
Top