Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need help with time formula
Hi all,
I could really use some help with an issue I have been dealing with at work. I have a program that outputs data with a timestamp attached. The problem is the timestamp is shown in seconds after midnight that day. What I need is an excel formula that would convert an integer such as this "34908" to a time format such as 2:30 pm. Any help would be greatly appreciated. Armadeus |
#2
|
|||
|
|||
On Fri, 12 Nov 2004 19:26:17 -0600, "daryl" wrote:
Hi all, I could really use some help with an issue I have been dealing with at work. I have a program that outputs data with a timestamp attached. The problem is the timestamp is shown in seconds after midnight that day. What I need is an excel formula that would convert an integer such as this "34908" to a time format such as 2:30 pm. Any help would be greatly appreciated. Armadeus Excel expresses time as fraction of a day. So, in Excel, the time could be expresses as =timestamp/secs_in_day or =timestamp/(24*60*60) =timestamp/86400 Format the result as h:mm AM/PM --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Formula for time? | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Time / Formula to look at time difference | Excel Worksheet Functions | |||
Excel Time Duration Formula | Excel Worksheet Functions |