Total TIme worked

J

jlogan21

I am working on a spreadsheet which contains how many hours worked per
day and totals for the week and month. I am using the
=TEXT(B2-A2,"h:mm") formula to get the difference betwen the time I log
in and the time I log out to obtain my total hours for the day. Now how
do I add all those times to get the total worked for the week?
Then I want to total those 4 values for total time worked during the
month.
Should I not use the TEXT function? I tried just subtracting them but
then the total time does not come out right.
THanks for you help.
Jennifer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TIME CALCULATION 5
Function to calculate total hours worked in one week. 4
Adding up total hours worked on employee schedule using various criteria 0
Add Time Q 4
How do I total a long list of time calcs? 2
Time attendance calculation problem 1
Total Working hours If 2
trouble with calculating wages to hours worked 3

Top