+ Reply to Thread
Results 1 to 2 of 2

subracting time from date/24 time field

  1. #1
    Registered User
    Join Date
    05-08-2018
    Location
    Vancouver, Canada
    MS-Off Ver
    Ofice 2013
    Posts
    26

    subracting time from date/24 time field

    Hello,

    I was wondering if someone can help with a formula to subtract time from a field that has a date and a 24 time. I need to subract 7 hours from this date as a whole. So for example if it is:

    21/9/2019 12:00:00 it would turn to --> 21/9/2019 5:00:00

    20/9/2019 01:00:00 would turn to --> 19/9/2019 18:00:00

    I've attached the file that I am working.

    Really appreciate the help,

    Thanks,
    Ardi
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: subracting time from date/24 time field

    Try

    =A2-7/24
    Happy with my advice? Click on the * reputation button below

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Parse a date+time field into separate date and time cells
    By meowmeow22 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2019, 10:37 AM
  2. [SOLVED] Creating Time Field and a Date+Time Column
    By marshymell0 in forum Excel General
    Replies: 12
    Last Post: 06-14-2013, 11:30 AM
  3. [SOLVED] Extracted time from date/time field does not flag on =IF(TIME function.
    By Vlad717 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2013, 03:29 PM
  4. [SOLVED] Adding and subracting Time Values
    By jordanay in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-03-2012, 04:04 PM
  5. Excel 2007 : Subracting Date and Time
    By KLTurner in forum Excel General
    Replies: 2
    Last Post: 11-30-2011, 04:06 PM
  6. Replies: 4
    Last Post: 03-23-2010, 12:44 PM
  7. [SOLVED] Remove time from a date and time field? Format removes the displa.
    By oaoboc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-16-2005, 03:35 PM

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