Is it possible to calculate these parameters:
Time In
Time Out
Less time out for lunch
Then display results in hours and tenths of hours?
Excel timesheet calculation



Welcome to the Forum!
The answer to your question probably is "Yes" but I'm not sure I understand exactly what you want to do. Do you really mean calculate:
Time In
Time Out
Less time out for lunchDo you mean you will use these inputs to calculate total time worked in a day?

My example posted here might help you.
http://ozgrid.com/forum/viewthread.php?tid=302
You will need to play with custom number formats to achieve tenths of an hour

Hi,
I have just checked my previous example and it calculates the total in decimal hours (multiply by 24)
Oh, just noticed that this is your first post so a big "Welcome to Ozgrid" :drum:

While RoyUK was posting, I was putting together a small example, too. For what it's worth, here it is; but mostly "What he said."


Here is an updated example that includes the times you mentioned in your U2U message.

Quote
Originally posted by Mamamech
Is it possible to calculate these parameters:
Time In
Time Out
Less time out for lunch
Then display results in hours and tenths of hours?Hi, take a look at these sites; they give a excellent timesheet overview and each has a sample download file.
2rrs
http://www.cpearson.com/excel/overtime.htm

Hi Mamamech
Plenty of help already, but you might like to read our page on Excel Dates and Times This will teach you the very important fundamentals for working with Dates and Times in Excel.

Sorry,
gave cpearson site twice, should have been:http://www.mvps.org/dmcritchie/excel/datetime.htm
2rrs
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!