time formatting

P

Peter Nelson

I have a data set with a column of times (from a text file) given as 643,
859, 1007, 1524, etc that I'd like to convert to h:mm, i.e. 6:43, 8:59,
10:07, 15:24. (I need to calculate the time interval between successive
data.) Can someone provide the formula? Obviously reformatting with
Format>Cells>Number>Time>(any option) fails...

Thanks! Pete
 

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

Help with time formats in Excel 2007, 0
How do I calc the time difference in hh:mm for shift work? 12
Formatting time 2
Lookup and average data in an unsorted list 1
Tinme calculations once more 11
Time formats 6
Averaging Time 8
How do I set up my data extraction 1

Top