Results 1 to 4 of 4

Thread: Extract Time in 24H format from Date and time.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-26-2016, 04:40 PM #1
    zorro
    zorro is offline
    Junior Member
    Join Date
    Aug 2016
    Posts
    12
    Rep Power
    0

    Extract Time in 24H format from Date and time.

    Please see the attached sheet, i need to calculate the no events in each shift

    Shift A - 8.31 PM - 4.30 AM
    Shift B - 4.31 AM - 12.30 PM
    Shift C - 12.31 PM - 8.30 PM
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Extract Date and time from the Text Column
    By zorro in forum Excel Help
    Replies: 19
    Last Post: 09-17-2016, 10:16 AM
  2. Calculate Difference Between Start Date Time And End Date Time
    By zorro in forum Excel Help
    Replies: 7
    Last Post: 08-25-2016, 04:14 PM
  3. Extract Time from a Date&time cell
    By Feebles in forum Excel Help
    Replies: 4
    Last Post: 11-09-2015, 06:24 AM
  4. Displayin Date/Time in "original" time zone
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-21-2012, 02:02 AM

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
  •  

Forum Rules