-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Time in 100ths of a minute
- Thread starter zaxsan
- Start date
erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
Hi,
this works for me
=TEXT(FLOOR(A1,1/1440),"UU:MM") &"," & ROUND(SECOND(A1)/0.6,0)
perhaps wait for a formulaguru
kind regards,
Erik
EDIT: no need for FLOOR, which was left over from previous experiment
=TEXT(A1,"UU:MM") &"," & ROUND(SECOND(A1)/0.6,0)
this works for me
=TEXT(FLOOR(A1,1/1440),"UU:MM") &"," & ROUND(SECOND(A1)/0.6,0)
perhaps wait for a formulaguru
kind regards,
Erik
EDIT: no need for FLOOR, which was left over from previous experiment
=TEXT(A1,"UU:MM") &"," & ROUND(SECOND(A1)/0.6,0)
Upvote
0
ravishankar
Well-known Member
- Joined
- Feb 23, 2006
- Messages
- 3,566
Hi
Paste the following codes in the macro window ( Alt F8)
run the macro.
It displays clock in Cell A1 with seconds as a decimal. I could not eliminate 0 behind the dot. secondly it does not seem to stop ticking though it is supposed to cycle for 5 rounds only. each cycle should last one second. (pause time = 1)
Ravi
Paste the following codes in the macro window ( Alt F8)
Code:
Sub clock()
For a = 1 To 5
a = Time()
Cells(1, 1).Font.Size = 16
Cells(1, 1).Font.ColorIndex = 3
Cells(1, 1).Font.Bold = True
Cells(1, 1).Interior.ColorIndex = 6
Cells(1, 1) = Hour(a) & ":" & Minute(a) & "." & Round(Second(a) / 60, 2)
PauseTime = 1
Start = Timer
Do While Timer < Start + PauseTime
DoEvents
Loop
Next a
End SubIt displays clock in Cell A1 with seconds as a decimal. I could not eliminate 0 behind the dot. secondly it does not seem to stop ticking though it is supposed to cycle for 5 rounds only. each cycle should last one second. (pause time = 1)
Ravi
Upvote
0
Ravishankar.....the Macro works great. I was not sure what you were talking about regarding the 5 rounds. I would like it to continue forever until I disable the macro.
It seams to jump numbers every now and then. It wil go 1,2,4,6,7,8,10,12,...... The time is correct though. I guess my computer is not fast enough to handle the changes that quickly? (P4 1.8)
erik.van.geit
I could not get your formula to work......any sugestions?
It seams to jump numbers every now and then. It wil go 1,2,4,6,7,8,10,12,...... The time is correct though. I guess my computer is not fast enough to handle the changes that quickly? (P4 1.8)
erik.van.geit
I could not get your formula to work......any sugestions?
Upvote
0
erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
sorry,
I missed the automatic part
it asumes you have the "regular" time in cell A1
I've not much time at this moment: having time running in a cell is not the best thing to do. Your UNDO will be disabled. You would better use a textbox. I'm sure there is some code on the board to do that (posted some myself)
best regards,
Erik
(I'll get back here if you want: just add a reply: have to run know)
I missed the automatic part
it asumes you have the "regular" time in cell A1
I've not much time at this moment: having time running in a cell is not the best thing to do. Your UNDO will be disabled. You would better use a textbox. I'm sure there is some code on the board to do that (posted some myself)
best regards,
Erik
(I'll get back here if you want: just add a reply: have to run know)
Upvote
0
Similar threads
- Solved
- Solved
