A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Decimal to 24 hour clock please.



 
 
Thread Tools Display Modes
  #21  
Old June 9th, 2005, 04:54 AM
Max
external usenet poster
 
Posts: n/a
Default

"Biff" wrote
Don't feel bad.


Not at all g. But of course, I must be accountable for the earlier goofy,
flawed attempts to help the OP. Harlan was spot on with his suggestion to
the OP and his descripts/comments on my earlier efforts. All are accepted
in good spirit.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik atyahoodotcom
----


  #22  
Old June 9th, 2005, 07:16 AM
Steved
external usenet poster
 
Posts: n/a
Default

Thanks Harlan.

"Harlan Grove" wrote:

"Steved" wrote...
Hello from Steved

1.43 to 1343
9.52 to 2152
3.17 to 1517
I have the above in decimal please a formula to 24hour clock as above

ie 3.17 to become 1517 not 15.17


Far & away the shortest and fastest way would be

=(x+12)*100



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to measure the distance between two lat and long points A new kind of measurement Running & Setting Up Queries 6 January 14th, 2005 04:45 PM
subtracting times using 24 hour clock andrew pronto Worksheet Functions 6 November 28th, 2004 02:26 AM
Time on outlook received messages is one hour behind clock on lap. Time Challenged General Discussion 1 September 16th, 2004 08:59 PM
y axis based on a 24 hour clock diane Charts and Charting 4 December 4th, 2003 05:02 PM


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


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