Posted by admin | Under gazages.com
Monday Mar 15, 2010
I want to creat an excel spreadsheet where I can add time. For
example lets say I clock in at 2:00 (in this format) in the afternoon
and I take a lunch at 6:00. I return to work at 6:30 and I leave at
9:00. That's 6 and a half hours I have worked. How would I be able
to do this in excel?
henryfranco,
The commenters below gave you many ideas to work on your Excel
problem. I would like to also show you a resource where you can anser
all your excel questions.
http://www.exceltip.com/search/Time.html
Excel Tip gives you a comprehensive search forum to locate tips and
ideas on how to do specific functions in Excel. For example, the URL I
listed there gives you things you can do with time in Excel, and
answers your question right here.
http://www.exceltip.com/st/Calculating_the_difference_between_hours_in_Microsoft_Excel/97.html
http://www.exceltip.com/images/screenshots/97.gif ( Screenshot)
"Calculating the difference between hours in Microsoft Excel
Calculate an employee's working hours. In the screen shot, notice the
format in Cells E4:E8 is hh:mm. The number 1 in the formula IF
represents a time value that exceeds 24 hours in a day.
See line 5 in the example. An employee named Mark arrived at work at
23:00 in the evening and finished work at 7:00 the next morning. The
result is calculated as 8:00 working hours."
There you go henryfranco. I hope this helps you with this question and
all your Excel needs. If this answer requires further explanation,
please request clarification before rating it, and I'll be happy to
look into this further.
Nenna-GA
Google Answers Researcher
#If you have any other info about this subject , Please add it free.#
