determining fractional seconds from serial time
How do I get fractions of a second from the serial time?
If I do format( t, "hh:mm:ss.sss") where t is the time I'm looking at, all the fractional part does is repeat the number of seconds as a repeating fraction. I tried dividing by 3600, 12, 12 in order but that gives me the wrong answer... David Gerstman |
determining fractional seconds from serial time
format( t, "hh:mm:ss.000")
-- HTH RP (remove nothere from the email address if mailing direct) "David Gerstman" wrote in message ... How do I get fractions of a second from the serial time? If I do format( t, "hh:mm:ss.sss") where t is the time I'm looking at, all the fractional part does is repeat the number of seconds as a repeating fraction. I tried dividing by 3600, 12, 12 in order but that gives me the wrong answer... David Gerstman |
determining fractional seconds from serial time
Hi Dave -
I tired this after reading your post and got a mis match error. Sub test() Dim temp As String temp = "" temp = FormatDateTime(Now, "hh:mm:ss.000") MsgBox temp Exit Sub my need is to measure a time interval in tenths of seconds. Can you help please? thanks, Neal Z. "Bob Phillips" wrote: format( t, "hh:mm:ss.000") -- HTH RP (remove nothere from the email address if mailing direct) "David Gerstman" wrote in message ... How do I get fractions of a second from the serial time? If I do format( t, "hh:mm:ss.sss") where t is the time I'm looking at, all the fractional part does is repeat the number of seconds as a repeating fraction. I tried dividing by 3600, 12, 12 in order but that gives me the wrong answer... David Gerstman |
determining fractional seconds from serial time
Hi Bob -
I tried this and got the seconds just fine, but the tenths of seconds always show as zero. Is there a ways to show tenths of secons? thanks. Neal Z. "Bob Phillips" wrote: format( t, "hh:mm:ss.000") -- HTH RP (remove nothere from the email address if mailing direct) "David Gerstman" wrote in message ... How do I get fractions of a second from the serial time? If I do format( t, "hh:mm:ss.sss") where t is the time I'm looking at, all the fractional part does is repeat the number of seconds as a repeating fraction. I tried dividing by 3600, 12, 12 in order but that gives me the wrong answer... David Gerstman |
determining fractional seconds from serial time
But _Bob_ used plain old Format--not FormatDateTime.
Did you try that? Neal Zimm wrote: Hi Dave - I tired this after reading your post and got a mis match error. Sub test() Dim temp As String temp = "" temp = FormatDateTime(Now, "hh:mm:ss.000") MsgBox temp Exit Sub my need is to measure a time interval in tenths of seconds. Can you help please? thanks, Neal Z. "Bob Phillips" wrote: format( t, "hh:mm:ss.000") -- HTH RP (remove nothere from the email address if mailing direct) "David Gerstman" wrote in message ... How do I get fractions of a second from the serial time? If I do format( t, "hh:mm:ss.sss") where t is the time I'm looking at, all the fractional part does is repeat the number of seconds as a repeating fraction. I tried dividing by 3600, 12, 12 in order but that gives me the wrong answer... David Gerstman -- Dave Peterson |
determining fractional seconds from serial time
Option Explicit
Sub test() Dim temp As String Dim temp1 As String Dim myTime As Variant 'just to make sure that there's a fraction of a second myTime = Now / 10 temp = Application.Text(myTime, "hh:mm:ss.000") temp1 = Format(myTime, "hh:mm:ss.000") MsgBox temp & vbLf & temp1 End Sub VBAs format behaves slightly different than the =text() worksheet function. Neal Zimm wrote: Hi Bob - I tried this and got the seconds just fine, but the tenths of seconds always show as zero. Is there a ways to show tenths of secons? thanks. Neal Z. "Bob Phillips" wrote: format( t, "hh:mm:ss.000") -- HTH RP (remove nothere from the email address if mailing direct) "David Gerstman" wrote in message ... How do I get fractions of a second from the serial time? If I do format( t, "hh:mm:ss.sss") where t is the time I'm looking at, all the fractional part does is repeat the number of seconds as a repeating fraction. I tried dividing by 3600, 12, 12 in order but that gives me the wrong answer... David Gerstman -- Dave Peterson |
determining fractional seconds from serial time
Dear Dave -
Thanks so much. Yes the vba format does differ from the application.text approach. a.text WORKS. (and the other does NOT) I ran the sub below about 20 times. Temp1 always showed .000 and temp varied the fraction. Thanks again, Neal "Dave Peterson" wrote: Option Explicit Sub test() Dim temp As String Dim temp1 As String Dim myTime As Variant 'just to make sure that there's a fraction of a second myTime = Now / 10 temp = Application.Text(myTime, "hh:mm:ss.000") temp1 = Format(myTime, "hh:mm:ss.000") MsgBox temp & vbLf & temp1 End Sub VBAs format behaves slightly different than the =text() worksheet function. Neal Zimm wrote: Hi Bob - I tried this and got the seconds just fine, but the tenths of seconds always show as zero. Is there a ways to show tenths of secons? thanks. Neal Z. "Bob Phillips" wrote: format( t, "hh:mm:ss.000") -- HTH RP (remove nothere from the email address if mailing direct) "David Gerstman" wrote in message ... How do I get fractions of a second from the serial time? If I do format( t, "hh:mm:ss.sss") where t is the time I'm looking at, all the fractional part does is repeat the number of seconds as a repeating fraction. I tried dividing by 3600, 12, 12 in order but that gives me the wrong answer... David Gerstman -- Dave Peterson |
All times are GMT +1. The time now is 09:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com