Forum Discussion
Marcel Gérin
Jan 30, 2018Copper Contributor
Time worked calculated. EX: 47,59,00 X $25 = 1224:35:00
47:59:00 X $25 = 1224:35:00 i want in $
3 Replies
Sort By
Hi Marcel,
In Excel time equivalent is number where 1 Hour = 1/24 (or 24 hours in one day). What you need to do is to multiply your hours on 24, after that on rate and apply currency format to the result, like
=A1*24*25
if hours are in A1 and 25 is your rate. If step by step then like
- EricStarkerFormer Employee
Thanks Dean!
Yes, I'm moving your question to the Excel space for better visibility.
- Dean_GrossSilver ContributorI would recommend that you repost your question in one of the application specific community spaces. That is where it will be seen by people with the appropriate expertise.