LinkBack URL
About LinkBacks
frankday 
I am creating a time card. I am trying to add the hours up for 5 days. for example if a person works from 8:00 to 16:30 every day it returns a value of 8:30 hours. The do that for 5 day. How do I get it to add up all the days. Sample TS 2012.xlsm
I am creating a time card. I am trying to add the hours up for 5 days. for example if a person works from 8:00 to 16:30 every day it returns a value of 8:30 hours. The do that for 5 day. How do I get it to add up all the days. Sample TS 2012.xlsm
Hi
If i understand, your request, then the problem is format problem.
Take a look to the example.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
That was a great help thanks. One more question. If you look at the total line I am trying to get it to take any hours over 40 and put it into anouther column under over time. But that calculation is not working. I am using an "if" statment.
Your formula there is OK.
Again the problem is the format in this cell(I16)
Use the same format as i did in my example in H16 and formula will give you the right result.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks