converting HH:MM to HH.MM

nasirmunir · July 10th, 2008, 03:16 PM

Do we have a pre-defined function in PHP to convert from time to decimal value? For example if a user enters 2:30 or 2.5, it should be displayed as 2.5 in both of the cases.
If we cannot handle it through PHP, then is there anything in javascript to do the same task ?
Any help would be greatly appreciated,

Thanks,

Old Pedant · July 10th, 2008, 07:02 PM

JS is easy enough.

But how did you get the HH:MM in the first place?? Is it just coming from some form field?

<form>
<input name="time" onChange="convertTime(this);">
</form>

<script>
function convertTime( what )
{
    var re = /^\d\d?\:\d\d$/;
    if ( re.test(what.value) )
    {
        var temp = val.split(":");
        hours = parseFloat( temp[0] );
        mins = parseFloat( temp[1] );
        what.value = hours + mins/60.0;
    }
}
</script>

That won't change the value entered unless it conforms to the regexp pattern given. Either h:mm or hh:mm

If you want to allow other patterns, you have to say so.

nasirmunir · July 10th, 2008, 08:54 PM

Thanks for the help, appreciate that.
yes, the input is coming from a field. A user is required to enter hours in decimal, but the user should also have an option of entering the value in hours. Example 2.5 or 2:30.
I was thinking of a way in PHP to convert the input to decimals in both cases and go from there. With javascript I have to perhaps add a function that can take the entered value and do the conversion. I will try with javascript as you have suggested, but I would be happy to find a solution in PHP as well.
Thanks again!!!

nasirmunir · July 11th, 2008, 08:10 AM

...the code is not functional, not working.

nasirmunir · July 11th, 2008, 09:08 AM

this one works fine:

Code:

<form name ="testform">
<input type = "text" name="time" onChange="convertTime()">
</form>

<script>
function convertTime( )
{
    alert("funtion...")
     alert(document.testform.time.value)
    var re = /^\d\d?\:\d\d$/
    if ( re.test(document.testform.time.value) )
    {
        alert("if...")
        var temp =document.testform.time.value.split(":")
        alert(temp[0])
        alert(temp[1])
        hours = parseFloat( temp[0] )
        mins = parseFloat( temp[1] )
       document.testform.time.value = hours + mins/60.0
    }
     alert("out...")
}
</script>

Old Pedant · July 11th, 2008, 01:33 PM

I give up. What did you change????

The only difference I see is that instead of passing in a reference to the form field using
    <input name="time" onChange="convertTime(this);">
and then receiving the reference in the function via
    function convertTime( what )

you chose to use
    document.testform.time.value

But those really are 100% equivalent. Did you perhaps forget to use this when you tried my version???