Results 1 to 6 of 6

Calculating cost

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2009
    Location
    Ohio
    MS-Off Ver
    Excel 2002
    Posts
    6

    Calculating cost

    Okay this is probably easy pickins for those who actually know Excel. But for those of us struggling to learn - any help is appreciated.

    Problem - billing spreadsheet for prisoner fee.

    1 - 8 hrs = $55
    9 - 24 hrs = $55 + $65 or $120
    Anything over 24 hrs - $65 for each additional (24 hrs) ($185)

    So if you were locked up for 6 hrs it is $55. If you were locked up for 18 hrs it is $120. If you were locked up for 28 hrs it is $185. And if you were locked up for 49 hrs it is $250.

    Cell F5 contains number of hours locked up - I would like cell I5 to calculate the cost of the stay.

    I am proud of myself for figuring out the date and time subtraction - but this part has me stumped.

    Thanks in advance
    Last edited by TMCEWAN259; 04-17-2009 at 09:22 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1