Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Anita Morales   on Feb 18 In MS Office Category.

  
Question Answered By: Grady Stewart   on Feb 18

If the time  is a normal date/time value it will not matter. The datetime
value is a decimal number of days since some long distant date that is it as
two parts and integer part for the day and a decimal part for the fraction
of a day.

If you use this variable you can subtract the start time from the end time
without problems. ten past  midnight will have a higher integer value than
ten to midnight the day before. You only need to check that the call  was
not completed before it started  by checking end<start.

If you have reinvented the way to track time I suggest you rethink.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Time difference calculations across midnight Or get search suggestion and latest updates.


Tagged: