Hi everyone,
When I am trying to convert the time into a serial number so I can have it in the excel time format, it is converting PM to AM. Is there any way to fix this? I know this post may be vague so if any more information is required from me please ask. Any help is appreciated!
Data Example.PNG
Try these formulae in the attached file.
Wheres your input data?
I see a description of the problem and a load of numbers but nothing describing what those numbers realte to.
Are they all input columns? Are they all output results?
What does your INPUT data actually look like?
Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks