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
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