Thread
:
Add colon to times
View Single Post
#
1
Posted to microsoft.public.excel.newusers
meridklt
external usenet poster
Posts: 4
Add colon to times
Is there a way to add a colon (:) to times?
Example: At the moment I have
A1 (hours) 2
B1 (minutes) 4
C1 (seconds) 8.321
I want these to end up in a single time cell as 2:4:8.321
Reply With Quote
meridklt
View Public Profile
Find all posts by meridklt