0

I have a very huge sheet with date and time values. I am exporting the calendar start date and end date into excel from outlook. I just want the time value in the field. Upon searching i found an formula {=INT()} but its showing error. Attaching the snapshot of the sheet for your reference. Thank you.

Edit 1

| improve this question | | | | |
2

If your date-time value (actually are date-time values and not text looking like dates) would sit in A1 for example:

=A1-INT(A1)

And format your result to time. Also, when you don't need to do any calculations with these values, you could also just format the cells to only show the time.


In case your values are text values looking like date-time values try:

=TIMEVALUE(MID(A1,5,LEN(A1)))

That would give you a number you can custom format as time

| improve this answer | | | | |
  • Error. I have edited my answer and added a snapshot with your formula. – AHmed Sep 2 '19 at 15:45
  • Yes i do not have calculations for these date and time values. – AHmed Sep 2 '19 at 15:50
  • I can't see your edited answer with a snapshot of the error. Are you sure they not textvalues that look like dates? – JvdV Sep 2 '19 at 16:07
  • How to format the cells to only show the time? – AHmed Sep 2 '19 at 16:29
  • Have a look here. However you haven't answered if you sure these values are not just text that look like dates. – JvdV Sep 2 '19 at 16:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.