+ Reply to Thread
Results 1 to 4 of 4

Time - hourly countdown

  1. #1
    Registered User
    Join Date
    02-22-2008
    Posts
    20

    Time - hourly countdown

    I'm trying to setup a way to calculate the hours between two dates and times. For example,

    A34 - 21/07/2008 10:29 (via =NOW() formula)
    &
    B34 - 13/08/2008 16:00

    C34 - How can display the total no of hours between them which will reduce when refreshed? It's simple to do the time calculation (one minus the other) but this only ever works for the same day (5:30 result).

    What I'll be looking for is 576...etc. refreshing at each stage.

    Any thoughts?

  2. #2
    Registered User
    Join Date
    07-03-2008
    Location
    Scotland
    Posts
    58
    I think...

    =B34-A34

    Format cells - Number - Custom: [h]:mm:ss

  3. #3
    Registered User
    Join Date
    07-03-2008
    Location
    Scotland
    Posts
    58
    Just [h] if you don't want the minutes and seconds.

  4. #4
    Registered User
    Join Date
    02-22-2008
    Posts
    20
    Thanks mate - that worked nicely.

+ 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