How to convert a float/double value to a timestamp in PHP

Question

3.00/5 (2 votes)

See more:

Hello!

I want to convert a float/double ~~integer~~ value to a time stamp in PHP.

PHP

0.555 = 1:19:12 PM
// in Microsoft excel we use =TimeValue(0.555) 
// it return value: 1:19:12 PM

Thanks for your interest!

Posted 9-Aug-11 2:08am

vivek511

Updated 9-Aug-11 2:59am

Manfred Rudolf Bihy

v2

Add a Solution

Comments

CPallini 9-Aug-11 8:30am

Excel's TimeValue does the opposite, according to the documentation:
http://office.microsoft.com/en-us/excel-help/timevalue-HP005209316.aspx?CTT=5&origin=HP005199659

CPallini 9-Aug-11 8:59am

There's a not empty intersection of PHP and VBA functionalities, I guess.

Manfred Rudolf Bihy 9-Aug-11 9:07am

I just realized OP had written Excel in his post :doh:
I think I need to check more closely next time :)

CPallini 9-Aug-11 9:09am

I suppose I've accidentally deleted your reply. Sorry for that.

Manfred Rudolf Bihy 9-Aug-11 10:36am

Nope that was me! As I realized my blunder I deleted the post, but since you already replied we can still see that it once was there. (Only the originator can see his deleted comments / replies.

[no name] 9-Aug-11 9:13am

Sir i don't want excel function i need solution in PHP

CPallini 9-Aug-11 9:16am

What do you really need? In your code sample TimeValue gets the serial as argument, while the documentation states the opposite (it returns a serial).

[no name] 9-Aug-11 9:30am

Dear CPallini
Actually i prepare a function which return integer value 0.72916666666667 but i want to print 5:30:00 PM .

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Accepted Answer · 2011-08-09T03:25:00

PHP

$secondsInDay = 86400
# Time as a float must greater or equal to zero and less or equal to one.
$dayAsFloat = 0.555

# Determine the number of seconds
$totalSeconds = intval($secondsInDay * $dayAsFloat)

# Calculate number of seconds
$seconds = $totalSeconds % 60
$totalSeconds = $totalSeconds / 60

# Calculate number of minutes
$minuntes = $totalSeconds % 60
$totalSeconds = $totalSeconds / 60

# Calculate number of hours
$hours = $totalSeconds % 60

$timeString = sprintf("%'0#2d:%'0#2d:%'0#2d", $hours, $minutes, $seconds)

This will leave you with a time value where the hours run from 00 - 23. If you want AM/PM time you'd have to adjust for that.

Cheers!

—MRB

How to convert a float/double value to a timestamp in PHP

1 solution

Solution 1

Add your solution here

Preview 0

How to convert a float/double value to a timestamp in PHP

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us