How to convert time (Hour:Minutes:Seconds) to Seconds

0 views
Skip to first unread message

Pratibha Sharma

unread,
Aug 26, 2015, 1:49:54 AM8/26/15
to Excel VBA Lab
Dear Group,

I have a query. I want to convert time (Hour:Minutes:Seconds) to Seconds only.

Example data is mentioned below :

Time in System format Output
H:M:S S
3:20:35 12035
1:01:00 3660
1:00:00 3600
0:00:01 1
0:01:00



Rgds
PS		 60

Ashish Kumar

unread,
Aug 27, 2015, 12:15:36 AM8/27/15
to Excel VBA Lab
Dear Pratibha,

Check this...!



Regards
Ashish Kumar
Solved - Time Query.xlsx

Pratibha Sharma

unread,
Aug 27, 2015, 5:44:05 AM8/27/15
to Excel VBA Lab
Hi Ashish,

Thanks, It's working for me.


Rgds
PS

Ashu K

unread,
Aug 27, 2015, 6:05:20 AM8/27/15
to Excel VBA Lab
Dear Ashish Sir,

Formula is working fine. Thanks for sharing.



Thanks & Regards
Ashu Kenith
Reply all
Reply to author
Forward
0 new messages