Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Janelle
 
Posts: n/a
Default multiply time and currency

i am trying to calculate cost by time, example, calculate pay from a
timesheet. I would prefer to multiply with the numbers formatted by mm:ss,
but i can adjust the cost if it has to be hh:mm. The number of minutes that
i need to multiply is over 100.

I have started by rounding out the minutes and that is working, but if this
is the way i need to go, how do i get the seconds out?

thanks!
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
dollar amount versus Time Webitect Excel Worksheet Functions 2 March 4th 06 07:44 PM
Multiply currency sorrywm Excel Discussion (Misc queries) 5 December 22nd 05 02:56 PM
how to multiply time by money chriscadstud Excel Discussion (Misc queries) 2 October 30th 05 03:19 AM
add time and convert it to currency Sunny Excel Worksheet Functions 2 February 25th 05 01:05 PM
How do I multiply rate per hour by hours worked. MAC Excel Worksheet Functions 1 December 22nd 04 03:29 PM


All times are GMT +1. The time now is 08:08 AM.

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

About Us

"It's about Microsoft Excel"