I have a formula filled cell that is formatted custom hh:mm so for example A1 is 05:45 (5 hrs 45 minutes) Cell A2 is just the hourly chargeable rate e.g. £10.
How do i get cell A3 to return the number of hours x hrly rate - 5.75 hrs x 10 = £57.50? so A1 x A2 = A3.
and format as General, or Number, or Currency.Formula:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You, Sir, are a star. Thank you!
You're welcome. Thanks for the rep.
My pleasure
A time is a fraction of a day, that is, 24 hours. Hence multiplying the time by 24 converts it to a decimal fraction. However, Excel will assume the output is still a time, so you then need to format it as you wish.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks