LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Time calculation

Hi,

How can I convert a whole number representing seconds, e.g. 460, 1259, 82
etc into a number that displays minutes and seconds?

For example, 460 divided by 60 shows 7.66 minutes recurring and I want it to
show 7 minutes 40 seconds or 7.40

Thanks for your help
Jon
 
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
Time Sheet Calculation Frantic Excel-er Excel Discussion (Misc queries) 7 August 11th 06 06:33 PM
#VALUE! in Time Calculation michelle Excel Worksheet Functions 2 August 10th 06 08:54 PM
perform calculation only if current time is after 10 am julieskennels Excel Worksheet Functions 7 July 18th 05 08:07 PM
"Manual calculation" takes less time. Why? Kjetil Excel Discussion (Misc queries) 1 January 7th 05 12:28 AM
time calculation excel Gate Keeper Excel Worksheet Functions 1 December 31st 04 08:27 AM


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