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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com