469,903 Members | 1,467 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

how to convert the time which is hh:mm:ss to mm:ss

seshu
156 100+
Hi every body to morning my cousine has show his application and also his live db in that to sav the length of all the voice files he has saved in time format ie he took the datatype of time now i want to generate a an excell sheet of that table but here i want the time to be like mm:ss but not hh:mm:ss examle

the length of song sweet dreams is 01:12:35 now i want this to be shown as
72:35 how is there any procedure to convert directly in mysql or should i have to use a frontend code if i have to use the frontend code i dont have any problem in bringing the values from db but how to covert is the problem some plz help me out

regards
seshu
Apr 1 '07 #1
1 1928
je901
2
you can use Date.TimeOfDay.TotalMinutes for solve it.

example

Dim t As New Date(2007, 4, 1, 1, 12, 35)
MsgBox(Fix(t.TimeOfDay.TotalMinutes) & ":" & t.Second)


hope it helps.
Apr 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by hikums | last post: by
6 posts views Thread by Able | last post: by
2 posts views Thread by Robert Brown | last post: by
5 posts views Thread by kpp9c | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.