Results 1 to 2 of 2

Calculating time differences over different dates

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    Red face Calculating time differences over different dates

    Hi

    Is there any way of calculating the time difference between a range of dates & times, as shown below.

    I currently have the dates and times shown seperately in individual cells, into which the entries are made via a userform.

    All dates are (dd-mm-yy).
    All times are (hh:mm).

    e.g
    Scheduled
    Start Date = 03-01-10 Cell Ref = A1
    Start Time = 14:00 A2
    End Date = 03-01-10 A3
    End Time = 22:00 A4

    Actual
    Start Date = 03-01-10 A5
    Start Time = 18:00 A6
    End Date = 04-01-10 A7
    End Time = 02:00 A8

    Time difference between (A4-A2) and (A8-A6). Cell reference = A9 (will always be positive).

    I can get it to work when I format the cells to show dates AND times but I have opted to split them as I do not know how to provide them combined via a userform.

    Many thanks,

    Andy
    Last edited by AndyE; 01-04-2010 at 03:03 PM.

Thread Information

Users Browsing this Thread

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

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