Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Format
Is there any way to custom time format to have milli-seconds also apart from
HH:MM:SS tHANKS & rEGARDS -- Dr. Sachin Wagh MBBS, DHA, DPH |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Format
Hi,
Custom format of hh:mm:ss.000 Put =Now() in the cell and Tap F9 and you'll see the time update including milliseconds Mike "Dr. Sachin Wagh" wrote: Is there any way to custom time format to have milli-seconds also apart from HH:MM:SS tHANKS & rEGARDS -- Dr. Sachin Wagh MBBS, DHA, DPH |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Format
Thanks a Ton Mike
You guys have kept Excel lively; the tip solves my problem. Just in case I'm not stretching it too far, is there any method in which the F9 can be kept continuosly operational (just like a watch) Thanks & Regards -- Dr. Sachin Wagh MBBS, DHA, DPH "Mike H" wrote: Hi, Custom format of hh:mm:ss.000 Put =Now() in the cell and Tap F9 and you'll see the time update including milliseconds Mike "Dr. Sachin Wagh" wrote: Is there any way to custom time format to have milli-seconds also apart from HH:MM:SS tHANKS & rEGARDS -- Dr. Sachin Wagh MBBS, DHA, DPH |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Format
Hi,
Yes you can do that but need to bear in mind that while the workbook is updating this clock the performance 'may' deteriorate. Try this. Put these 2 short macros in 'This Workbook' Private Sub Workbook_Open() Application.OnTime Now + TimeValue("00:00:8"), "CalcMacro" End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.OnTime dTime, "CalcMacro", , False End Sub And this one in an ordinary module Public dTime As Date Sub CalcMacro() dTime = Now + TimeValue("00:00:08") Application.OnTime dTime, "CalcMacro" Application.Calculate End Sub You can set the time interval to update to what you want, currently set at 8 seconds. Mike "Dr. Sachin Wagh" wrote: Thanks a Ton Mike You guys have kept Excel lively; the tip solves my problem. Just in case I'm not stretching it too far, is there any method in which the F9 can be kept continuosly operational (just like a watch) Thanks & Regards -- Dr. Sachin Wagh MBBS, DHA, DPH "Mike H" wrote: Hi, Custom format of hh:mm:ss.000 Put =Now() in the cell and Tap F9 and you'll see the time update including milliseconds Mike "Dr. Sachin Wagh" wrote: Is there any way to custom time format to have milli-seconds also apart from HH:MM:SS tHANKS & rEGARDS -- Dr. Sachin Wagh MBBS, DHA, DPH |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Format
Thanks Mike
-- Dr. Sachin Wagh MBBS, DHA, DPH "Mike H" wrote: Hi, Yes you can do that but need to bear in mind that while the workbook is updating this clock the performance 'may' deteriorate. Try this. Put these 2 short macros in 'This Workbook' Private Sub Workbook_Open() Application.OnTime Now + TimeValue("00:00:8"), "CalcMacro" End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.OnTime dTime, "CalcMacro", , False End Sub And this one in an ordinary module Public dTime As Date Sub CalcMacro() dTime = Now + TimeValue("00:00:08") Application.OnTime dTime, "CalcMacro" Application.Calculate End Sub You can set the time interval to update to what you want, currently set at 8 seconds. Mike "Dr. Sachin Wagh" wrote: Thanks a Ton Mike You guys have kept Excel lively; the tip solves my problem. Just in case I'm not stretching it too far, is there any method in which the F9 can be kept continuosly operational (just like a watch) Thanks & Regards -- Dr. Sachin Wagh MBBS, DHA, DPH "Mike H" wrote: Hi, Custom format of hh:mm:ss.000 Put =Now() in the cell and Tap F9 and you'll see the time update including milliseconds Mike "Dr. Sachin Wagh" wrote: Is there any way to custom time format to have milli-seconds also apart from HH:MM:SS tHANKS & rEGARDS -- Dr. Sachin Wagh MBBS, DHA, DPH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Convert time stored as decimalised number to time format | New Users to Excel | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |