need help with time formula

  • Thread starter Thread starter daryl
  • Start date Start date
D

daryl

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
 
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
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a Static Timestamp Formula 2
Time Sum in Excel 1
Excel Dragging countif formula with changing criteria 3
Extracting just the time portion 5
Now formula problem 4
Adding Time 7
Calculating time for 3rd shift 4
Calculate hours, past midnight etc 4

Back
Top