How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

i WOULD LIKE TO TYPE TIME INTO CELL 1,2,3 WITHOUT ENTERING

Resolved Question:

i WOULD LIKE TO TYPE TIME INTO CELL 1,2,3 WITHOUT ENTERING A COLON THEN SUBTRACT CELL 2-1-3 AND COME UP WITH A CUMULATIVE TIME IN CELL4 ALL IN 24 HOUR CLOCK AND THEN MULTIPLY THE ANSWER IN CELL 4 TO A VALUE IN CELL 5 AND PRODUCE ANOTHER CUMULATIVE TIME IN CELL 6
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  John D replied 5 years ago.

Hi,


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)

 

Customer: replied 5 years ago.

i have a file how do i attach it

 

Expert:  John D replied 5 years ago.

 

graphic

Customer: replied 5 years ago.
Expert:  John D replied 5 years ago.

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

 

 

 

Customer: replied 5 years ago.

input time as 24 hour without typing a colon in cells C8,D8,E8

 

set cells D8-C8-E8=F8

 

F8 x G7 =G8

Expert:  John D replied 5 years ago.

which sheet?

 

Customer: replied 5 years ago.
sorry sheet #4 Unit hours tally sheet
Expert:  John D replied 5 years ago.

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

 

Attachment: 2012-03-05_021002_time_calculation.xls

 

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

 

 

 

Customer: replied 5 years ago.

never mind i already figured it out

Expert:  John D replied 5 years ago.

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.

 

Thank you

 

 

 

 

Customer: replied 5 years ago.

i can't see the formulas in your cells

 

Expert:  John D replied 5 years ago.

As I said I will provide the formulas on your file once you have tested them on this file and found them ok.

 

 

John D and other Microsoft Office Specialists are ready to help you
Expert:  John D replied 5 years ago.

Thanks

 

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

 

Attachment: 2012-03-05_035241_time_calculation1.xls

 

Hope this is ok. Let me know if you have any questions

 

 

Related Microsoft Office Questions