+ Reply to Thread
Results 1 to 2 of 2

Calculating a waiting time

  1. #1
    Registered User
    Join Date
    01-12-2010
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Calculating a waiting time

    Hello chaps, I'm in a spot of bother. I need a formula that will calculate the total waiting time from the date of a patient's referral to the date of the patient's first appointment and display the value in days.

    In essence...

    [Referral date] 01/01/2010 [Date of first appointment] 10/01/2010 [Waiting time] 9 days

    Would be very grateful for any help.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Calculating a waiting time

    Assuming Appointment is B1 and Referral is A1 then:

    C1: =B1-A1
    format as General

    (not clear what you want to happen should no Appointment exist)

+ Reply to Thread

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