+ Reply to Thread
Results 1 to 4 of 4

how to determin how many hours between two different times

  1. #1
    Registered User
    Join Date
    05-12-2012
    Location
    Geelong,Victoria
    MS-Off Ver
    Excel 207
    Posts
    3

    Post how to determin how many hours between two different times

    The formula needs to determine the difference between B10 & C10. d10 is to display the difference. I have tried formatting cells to Time but this doesn't work as it returns "Value"

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: how to determin how many hours between two different times

    =C10-B10 formatted it as "h" ?
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: how to determin how many hours between two different times

    Hi Dotty

    The difference in time: = end_time - start_time.
    For your #VALUE error, see the article at Microsoft.

  4. #4
    Registered User
    Join Date
    05-12-2012
    Location
    Geelong,Victoria
    MS-Off Ver
    Excel 207
    Posts
    3

    Re: how to determin how many hours between two different times

    Quote Originally Posted by vlady View Post
    =C10-B10 formatted it as "h" ?
    Thanks for that, I have tried but still could not get it to work. I am very new to this so what does formatted as "h" mean

+ 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