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

1 Answer

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

8

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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