LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Time remaining until event

Countdown to event timing.....

Hi, Im trying to build a workbook in Excel 2007 that is able to calculate
the amount of time REMAINING until the start of a scheduled event and return
the number of hours, minutes and seconds remaining until the scheduled start
time, however if the event does not start on time I want to be able to see
how many hours, minutes and seconds the event is running late.

I have built a worksheet that returns the following information (hh:mm:ss)

Current Time 13:25:34
Expected Start Time 14:00:00
Variance 00:34:26

However if an event starts later than expected I want the return to look
like this:

Current Time 14:07:44
Expected Start Time 14:00:00
Variance (00:07:44)

Instead what I actually get is either Variance = 23:59:59 or Variance = VALUE!

Any help that you can give would be great, please include any details
regarding the cell formatting as I suspect that this is where Im going wrong.

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
#of days remaining to the EOM Narnimar Excel Discussion (Misc queries) 5 September 15th 08 07:53 PM
Number of payments remaining Erik Excel Worksheet Functions 4 May 29th 08 12:22 PM
calculate remaining pay periods maijiuli Excel Worksheet Functions 5 January 24th 08 10:32 PM
Getting remaining entries harvindersingh1 Excel Discussion (Misc queries) 1 April 21st 06 03:32 PM
Points remaining formula jbsand1001 Excel Worksheet Functions 0 January 5th 05 10:55 PM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"