Time Formula ???

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

Bob Phillips

=($G$1-c1)*24*60

formatted as general

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
What is in G1?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
I see it now, it has Now(), which includes the date

Use =($G$1-INT($G$1)-C2)*24*60 instead

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
See my other post, I think it has the answer.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi


Graham Feeley said:
Hi Barb, thanks for the reply, checked the system date/time and it seems to
be correct. eg: the time right now is 3:00:42 AM in Aust. (Can't sleep)
Click to expand...

You are a day too early here (somewhat like "Back to future", or what.). Or
you have wrong date set, or you have messed up your computers time zone.


Arvi Laanemets
 
Hi

=IF((NOW()-TODAY())>G2;"gone";G2-(NOW()-TODAY()))
and format with any valid date format you like


Arvi Laanemets
 
Ok,Ok,Ok Barb picked me up on this and I checked the system however the time
was ok but my Time Zone was not aligned.
Thanks for alerting me to this
I will now try the formula
let you know
Regards
Grah
 
Hi Barb, thanks for the reply, checked the system date/time and it seems to
be correct. eg: the time right now is 3:00:42 AM in Aust. (Can't sleep)
..
Using Bob's formula " =($G$1-c2)*24*60" it gives me the result in D:2 " as
55274185
the time of the first bus in C:2 is 6:36:00 AM
---------------------------------
 
Prob not explaining it correctly....sorry for that, I will try to clear it
up a little
G:1 contains the formula "=Now()"
and it is formatted as Time, which give me as of right now
3:33:00 AM
c:2:c55 Contains various times the buses leave, and it is formatted as time,
which gives me in c2 6:34:00 AM
 
I have been trying to do this myself, but just can't get around it.
I have various worksheets with bus routes and timetables.
These are the columns.
A BusNo
B Day...Text "M" means Mon thru Friday,"S" means Saturday,"F" means Friday
only,"Su" means Sunday....I can filter with this col.
C Time.........Formatted as 1:30:00 AM.....Time of the Bus connection
D =timediff
G:1 = Now() ...Formatted as 1:30:00 AM
I would like the col "TimeDiff" to tell me how many minutes to the next bus
?????????
I was using the formula in D:D =MINUTE($G$1-C2)
Which is not what i want
Can anyone please help?
Regards
Graham
 
Back
Top