Hello all,
i got under A worng time format showing as
736
1645
actualy this original data is numeric and not a time format at all
is there a way to convert so under B wil show as
07:36:am
16:45:pm
thanks
Hello all,
i got under A worng time format showing as
736
1645
actualy this original data is numeric and not a time format at all
is there a way to convert so under B wil show as
07:36:am
16:45:pm
thanks
Use another column with this formula
=TIME(B1/100,A1-INT(B1/100)*100,0)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Chip Pearson has a quick time entry method
http://www.cpearson.com/excel/DateTimeEntry.htm
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
i need help with the date time stamp:
when i type data in A2 i want B2 to automatically add in the time and the date, ive gotten this to work - only problem is when i drag the formula down and i type info in A3 etc it changes all the dates and times to the current date and time, i need each date and time to be different and to be as per what was filled into A2, A3 etc and not change.... please help
Start a new thread, don't hijack someone else's.
did not work i always get 12:00:00 in B
Try using this
=TIME(MID(A2,1,LEN(A2)-2),RIGHT(A2,2),0)
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
In B1, then copy down
=TEXT(A1,"00\:00")+0
Format as time.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
@ DGagnon
@ Haseeb A
thanks all it worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks