Results 1 to 3 of 3

Thread: Turning durations in hh:mm:ss into costs

  1. #1

    Turning durations in hh:mm:ss into costs



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there

    I have an export that shows me duration against task in hh:mm:ss. I need to work out the cost of that time. Eg, if one hour costs $50, then how much does 00:20:14 cost?

    Thanks

    Casi

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =(A2*24)*50

    you can replace the 50 with cell reference containing the unit cost.


  3. #3
    Quote Originally Posted by NBVC View Post
    Try:

    =(A2*24)*50

    you can replace the 50 with cell reference containing the unit cost.
    Yes, perfect, thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •