LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default Mathematical Time Conversion Formula

Hello Everyone...

I have a question about converting a segment of time between minutes,
and 100th's. Let me try to explain more clearly.

We have two places that keeps track of an employee's earned time off
(ETO). On their pay stub, the amount is tracked in 100th's of an hour
(may not be saying that correctly). So, an employee can have 21.84
hours of ETO, but this is actually 21 hours and 50 minutes (.84*.6).
So, in one location, the employee can see 21.84 hours, and in another
they see 21.50 hours... Here in lies the issue... I can easily take the
..xx numbers and multiply by .6 to convert to actual minutes. However,
how can I write a formaula that looks at the whole number (21.84), and
converts it in another cell to read 21.50? Is there an easy way?

Cell A1 Cell A2
21.84 (formula that shows 21.50)

As always, thanks ahead of time for any assistance.

 
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
A mathematical formula question??? Rameris Excel Worksheet Functions 3 May 23rd 09 01:24 PM
Need a formula for time conversion LBaker Excel Discussion (Misc queries) 8 February 14th 09 09:11 AM
Need a formula for time conversion LBaker Excel Worksheet Functions 6 February 13th 09 11:45 PM
mathematical formula of rate mich Excel Discussion (Misc queries) 5 July 12th 06 10:54 AM
Please help with an excel mathematical formula EduardoDon Excel Discussion (Misc queries) 1 August 4th 05 06:23 PM


All times are GMT +1. The time now is 01:36 PM.

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"