How do I write a formula to tell if one time of the day is further along than the other:
I am not using military time, all my data is in the 12hr format.
Example: 1:00 PM and 11:00 AM, How do I write a formula to tell if 1:00 Pm is 2hours greater than 11:00AM
If A1=1:00PM, A2=11:00AM both are formated as time
=A1-A2=2
Quang PT
Perhaps
//Ola
=IF((A1-B1)>2,"Yes","No")
A1: 01:00 PM
B1: 11:00 AM
Mark the problem as Solved under the Yellow bar up Top right, under Thread Tools, when you received a solution.
It saves time, to skip already solved threads.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks