I will be happy to help you with this. Since the solution requires both formulas and special cell formatting I need to have your file so I can set it up for you.
Do you have the file available that you could send (let me know if you need help attaching files on this site)
i have a file how do i attach it
Got it, thanks
Could you tell me which cells are those that you referred to as Cells 1, 2, 3, 4, 5 and 6 and on which sheet
input time as 24 hour without typing a colon in cells C8,D8,E8
set cells D8-C8-E8=F8
F8 x G7 =G8
Unfortunatey that sheet is password XXXXX so I couldn't write formulas in its cells
Here is a sample file for your review and testing. The formulas are in the yellow cells
If this is ok thank you for clicking Accept. I will then set up the formulas on your file as soon as you provide the password
never mind i already figured it out
Good. But don't forget to click Accept so I can get paid for my time trying to assist you on this rather extended thread as well as preparing the solution.
i can't see the formulas in your cells
As I said I will provide the formulas on your file once you have tested them on this file and found them ok.
Ok what is the password XXXXX unprotect the 'UNIT HOURS TALLY SHEET' so I can write the formulas in the cells?
Or if you like to copy the formulas yourself here is the file with the formulas
Hope this is ok. Let me know if you have any questions