Time countdown

[ABSTRAKTUS]

Hi gurus,

I've really stucked with one of my spreadsheets where I need to calculate how much time I've got left before the earliest order needs to be despatched (it might be 2 or more on every day). This wouldn't be a problem if orders would be placed daily. But for every item it varies. For example: for "X" product there is an order in 3 days time to be despatched at 19:00. I have built a live clock in the spreadsheet but I can't work out the formula.

I've done dummy for you to look at if that helps. Any ideas guys?

Thanks in advance!

P.S. Also I need two time formats, first - days(text) hh:mm second - just a numeric value that can be formated as [hh:mm].

[foxguy]

This file should do what you asked for.

[ABSTRAKTUS]

Great! Thanks a ton mate! Well done! I need to study what INT formula does as first time I see it. Thanks again mate!

[foxguy]

Int(...) returns the integer part of a number.
Dates and Times are really numbers. The Integer part is the Day since 1901. The fraction part is hours & minutes & seconds.

[studiodave56]

I have a similar problem, I need to list multiple items that end in, ex: 45:14:50 - Hr:Mn:Sec and would like the date and time of completion or just a countdown to 0 would work. I will have 60 to 70 items running at the same time with different start times and lengths. Picture queueing up items at different times to complete in different length of time and I need to be ready when each item is done. I know this is an Excel forum but I also use Apple Numbers so if either one works better I'm fine with that. Thanks, Dave

[vlady]

Welcome to the forum Dave.

You have to create your own thread Dave. And if possible attached a sample file with expected output for the members to work with.

Thanks.