Closed Thread
Results 1 to 2 of 2

Want to represent durations with a number series

  1. #1
    Registered User
    Join Date
    01-09-2022
    Location
    UK
    MS-Off Ver
    2019
    Posts
    7

    Want to represent durations with a number series

    Hi,

    I have date and time data in column A. I want that date and time from 1/14/2022 0:00 to 1/14/2022 0:04 (from cell A2 to A926) should be written as 0 in column B.

    Let me explain this,
    1/14/2022 0:00 starts from cell A2 and
    1/14/2022 0:04 ends at Cell A926
    I want that for all these timestamps only this 0 should be written in the column B

    in the same way
    1/14/2022 0:05 starts from cell A927 and
    1/14/2022 0:09 ends at Cell A1602
    I want that for all these timestamps only this 1 should be written in the column B
    and so on


    in short, for all timestamps starting from 00:00 to 04:59 minutes should be written as 0
    for all timestamps starting from 00:05 to 09:59 minutes should be written as 1
    and so on

    (Sample file is attached for further clarification)
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,872

    Re: Want to represent durations with a number series

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...ml#post5620108
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. can Excel use number to represent text
    By David Mawer in forum Excel General
    Replies: 4
    Last Post: 12-04-2013, 11:45 AM
  2. Replies: 0
    Last Post: 03-26-2013, 08:38 PM
  3. Letters that need to represent number
    By Kelley_cindy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2013, 02:08 AM
  4. Replies: 11
    Last Post: 11-26-2012, 08:46 PM
  5. Colored cell to represent a number
    By JoeHan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2010, 05:17 PM
  6. Excel 2007 : How to make text represent a number.
    By jimleslie77 in forum Excel General
    Replies: 1
    Last Post: 02-02-2009, 05:17 PM
  7. How do I make a letter represent a number?
    By Ben Z. in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-10-2006, 05:32 PM
  8. How do I get a letter to represent a number for scheduling?
    By Henry Elliott in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1