Share via

Fraction number query

Anonymous
2022-09-23T05:35:38+00:00

Dear Concern,

I have a fraction numbers i.e. 4.62, I have to extract years, month and date from this fraction number in a single cell. can you please provide any formula and help me in this regards.

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-23T05:52:37+00:00

    That is not actually a fraction, it is a decimal.

    .

    You are in luck. Excel actually stores dates as a whole number series starting Jan1 1900. Year, month, day is implicit in that series. They are easy to extract in various ways

    Excel stores times as decimal values on the date series number.

    .

    So your value 4.62 translates to Jan 4, 1900 2:52 PM.

    .

    Please explain how you are using this value. I'm guessing it is a duration from some start point that you want to convert to a future date/time.

    .

    Here are some articles about how Excel handles dates/times

    Excel Date and Time Formatting codes

    https://www.myonlinetraininghub.com/excel-date-and-time-formatting

    October 20, 2017 by Mynda Treacy

    Even though dates and time are actually stored as a regular number known as the date serial number, we can make use of extensive Excel date and time formatting options to display them just the way we want.

    We can access some quick date and time formats from the Home tab > in the Number group
    . How to change date format in Excel and create custom formatting https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/

    by Svetlana Cheusheva | updated on November 2, 2021

    The first part of our tutorial focuses of formatting dates in Excel and explains how to set the default date and time formats, how to change date format in Excel, how to create custom date formatting, and convert your dates to another locale.

    Along with numbers, dates and times are the most common data types people use in Excel. However, they may be quite confusing to work with, firstly, because the same date can be displayed in Excel in a variety of ways, and secondly, because Excel always internally stores dates in the same format regardless of how you have formatted a date in a given cell.

    Knowing the Excel date formats a little in depth can help you save a ton of your time. And this is exactly the aim of our comprehensive tutorial to working with dates in Excel.  In the first part, we will be focusing on the following features:

    Was this answer helpful?

    0 comments