I have created a simple worksheet for a time sheet for a project, but can not get the numbers to work. I am sure it is an issue with formats, but I need assistance to fix. The worksheet screen shot is:
Column F is in General format showing units of hours (i.e. .50 = 1/2 Hour), G and H are start and end times where I is the net time for the line. The yellow highligt is the sum of the area where the time est = 8.5 hours and total time spent = 1:50 (one hour and 50 minutes). The difference between the yellow F-I I want to show 7 in column P (yellow), but it shows the odd value of .076....
How do I correct my worksheet to show the values expected?
Thank you in advance for your help!
Tom
Column F is in General format showing units of hours (i.e. .50 = 1/2 Hour), G and H are start and end times where I is the net time for the line. The yellow highligt is the sum of the area where the time est = 8.5 hours and total time spent = 1:50 (one hour and 50 minutes). The difference between the yellow F-I I want to show 7 in column P (yellow), but it shows the odd value of .076....
How do I correct my worksheet to show the values expected?
Thank you in advance for your help!
Tom
Last edited: