Hi guys I have a column with times in it, it seems to be formatted to HH:MM I would like to change this to HH:MM:SS but it will not seem to change at all by formatting the cells, does this mean I will need to go through each individual time and change it to the new format or is there some sort of work around?
Seems to be Text Numbers, can you please attach a sample workbook or screenshot for better understanding
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Here is a sample, the time column is column D.
Insert a new column in Column E
In E1 Cell
Formula:
Please Login or Register to view this content.
Drag it down...
Copy the formula cells and paste it as values and format the range as hh:mm:ss
Thank you very much that helps, one thng though the first cell always seems to change to #VALUE rather than time but the rest change to what they should be.
You may be having some text data instead of number value
Ah it is ok totally forgot I had a header in D1!
Hi,
I am having a similar issue. I would like to change the time format to h:mm AM/PM so I can calculate the difference between the start time and end time.
Administrative Note:Originally Posted by kmrz
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi All, have a list of date with seconds and i need to convert them to Hour:Minutes:seconds but when i chose h:mm:ss in custom format it doesnt change.
I watch some videos where they solve it it different column but i do have possibility to add new column as report is enough big. Could be kind to help me ?
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks