LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 158
Default Calculate if 2 times differ by 24 hours?

So, cell A1 contains a fixed time in the format of "hh:mm:ss",
and cell A2 contains a fixed data in the format of "mm/dd/yy".
Users will be entering a time into cell B1 and a date into
cell B2.

How can I determine if the times and dates entered into
cells B1 and B2 are greater than the fixed time and date
in cell A1 and A2 by more than 24 hours?

I hope that makes sense. I'm just looking for code to
do the calculation.

Thank you!

Robert


 
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
How do I calculate total pay from pay rate times hours and minutes Rufus Excel Discussion (Misc queries) 5 May 1st 23 07:45 PM
Calculate total for rate times hours in Excel? whitjl143 Excel Discussion (Misc queries) 3 September 22nd 09 07:17 PM
Calculate hours between to separate dates and times Dave08 New Users to Excel 7 October 13th 08 10:36 AM
How do I calculate dates and times, w/answer of days & hours Debby_Jo Excel Worksheet Functions 4 April 27th 07 04:05 AM
Calculate the number of hours between two dates and times [email protected] Excel Programming 1 October 19th 06 09:14 AM


All times are GMT +1. The time now is 06:30 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"