hr,min,sec
Hello
Is there a way to concatenate hrs, mins, sec into one cell? I have hrs in one cell , minutes in another, seconds in another (formatted right now as time) Thank you Terry |
hr,min,sec
Hi Terry
See this function =TIME(C1,D1,E1) -- Regards Ron de Bruin http://www.rondebruin.nl "Terry V" wrote in message ... Hello Is there a way to concatenate hrs, mins, sec into one cell? I have hrs in one cell , minutes in another, seconds in another (formatted right now as time) Thank you Terry |
All times are GMT +1. The time now is 05:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com