LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 542
Default Changing a number into time

In my sheets for work i have basic formulaes to work out a basic time such as

=SUM(F140/7+H140+J140-60)
Which is this the amount of packs per hour (f140) divided by how many packs
per minute (7) plus how much downtime (h140) plus the change over product
time (j140) take away 60.

Which gives a result of something like 13.85
Obvioulsy this is not in a time formatt.
At the end of the week it could look like 1363.99
How can i set the formulae to give me an actuall time so each one would not
need someone to look at it a go "oh thats so many hours and minutes", so that
it does it by use of a formulae.

Cheers James.

 
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
Round number to the thousands without changing underlying number Tim Caldwell Excel Discussion (Misc queries) 3 June 13th 07 09:37 PM
Changing Time To Different Timezones Sid Saul New Users to Excel 1 March 10th 07 08:46 AM
Changing many references at a time. rmellison Excel Discussion (Misc queries) 2 September 22nd 05 04:41 PM
Changing format of number without changing the value sweetsue516 Excel Discussion (Misc queries) 2 August 22nd 05 04:07 PM
stop number font size from changing each time i click on somethin. alibob26 Charts and Charting in Excel 1 May 25th 05 03:15 PM


All times are GMT +1. The time now is 01:07 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"