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 The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Software
Satisfied Customers: 2010
Experience:  20 years experience providing remote computer support
62934938
Type Your Software Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

WHEN THIS FORMULA Cell A1 =SUM(A63-B63)*24 SHOWS A RESULT I

This answer was rated:

WHEN THIS FORMULA Cell A1 =SUM(A63-B63)*24 SHOWS A RESULT I WANT AN-- hrs-- to appear next to result Is that Possibel. So In other words When Cell A1 reads 12 from calculating (A63-B63)*24
I want it to read 12HrsExcel on a Mac

Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question and will be back in a moment with my reply.

=((A63-B63)*24)&"Hrs"

not sure if that is what you are getting at.

Customer: replied 1 month ago.
When I did that I got this Message. To get assistance in entering a function, click OK,then click Function on the Insert menu.
• If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (')Didn't work

can you send your sheet?

Customer: replied 1 month ago.
OK I have a comment referencing your name in the comment Box CELL P4

ok here it is.

Had to change format to general

BONUS would be appreciated

Customer: replied 1 month ago.
Ok I will Tip after next response which has to do with same Question Can I have a space inserted after result between Number and Hrs Like 5 Hrs Instead of 5hrs

Do you mean 5 : 23

or the word hrs

5 hrs

Customer: replied 1 month ago.
The Letters--- Hrs

= 5 & " hrs"

just put any spaces inbetween quotes

The-PC-Guy and 2 other Software Specialists are ready to help you

thanks

no bonus this time?

not a big deal, but this is how i make a living

Customer: replied 1 month ago.
I did send a Bonus $10