Tags: cost, excel, microsoft, money, msdn, multiply, restaurant, rota, software, sum, time, waiters

how to multiply time for money

On Microsoft » Microsoft Excel

724 words with 1 Comments; publish: Fri, 23 May 2008 18:32:00 GMT; (30646.88, « »)

i'm doing a rota of a restaurant and i've got the sum of all hours of the

waiters

what i would like to know is how much it cost to the restaurant?

All Comments

Leave a comment...

  • 1 Comments
    • Hi

      If the times have been entered as Excel times then they will have been

      stored as fractions of a day.

      To multiply the hours by and hourly rate

      Hours worked * 24 * Rate per hour

      --

      Regards

      Roger Govier

      "vardasca" <vardasca.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:54002265-5EFD-4507-B5F8-E19FA4CD62C6.excel.todaysummary.com.microsoft.com...

      > i'm doing a rota of a restaurant and i've got the sum of all hours of

      > the

      > waiters

      > what i would like to know is how much it cost to the restaurant?

      #1; Fri, 23 May 2008 18:33:00 GMT