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. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
"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
|
|||
|
|||
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 | |
|
|
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 |