Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how to multiply time for money

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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default how to multiply time for money

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" wrote in message
...
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hot key for time? Dave in Des Moines New Users to Excel 2 March 24th 06 04:31 PM
Hot key for time? Dave in Des Moines Excel Worksheet Functions 2 March 24th 06 04:15 PM
Hot key for time? Dave in Des Moines Excel Discussion (Misc queries) 1 March 24th 06 03:46 PM
how to multiply time by money chriscadstud Excel Discussion (Misc queries) 2 October 30th 05 03:19 AM
time sheet to calculate 2 different columns John Sullivan Excel Worksheet Functions 1 October 21st 05 06:48 AM


All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"