how to compare between times in excel
hello developers,

i have an excel where employees shift time and log in time is present in two column

so i want details that today who is not log in on his shift time(who comes late at office)

[image]
[@manish\_patel](/u/manish_patel)

check as below

[[image]](https://aws1.discourse-cdn.com/uipath/original/3x/2/e/2e77ce85497a8ce450a3dde9b288abe7fc380f24.png "image")

attached workflow for your reference

[timedifferenceinexcel.zip](/uploads/short-url/jkrk9luusffty75tmi9bdijp9g0.zip) (17.1 kb)

mark as solution if this helps

thanks
Hi,  

  

check the following Code  

SQLCopy Code

```
-- Question 1 Answer
SELECT E.EmployeeID,E.Day, (E.TotalTime/60) 'TotalHours', (E.TotalTime%60) 'Minites'
FROM (SELECT EmployeeID,CONVERT(VARCHAR(10),FromTime,102) 'Day',SUM(DATEDIFF(mi,FromTime,ToTime)) 'TotalTime'
      FROM tblEmployeeTimeCard
      GROUP BY EmployeeID,CONVERT(VARCHAR(10),FromTime,102))E

-- Question 1&2 Answer
SELECT E.EmployeeID,E.Day, (E.TotalTime/60) 'TotalHours', (E.TotalTime%60) 'Minites',
CASE WHEN (E.TotalTime/60)>=6 THEN E.TotalTime - (30* ROUND((E.TotalTime/60*6),1))
     ELSE (E.TotalTime/60) END 'TotalWorkHours'
FROM (SELECT EmployeeID,CONVERT(VARCHAR(10),FromTime,102) 'Day',SUM(DATEDIFF(mi,FromTime,ToTime)) 'TotalTime'
      FROM tblEmployeeTimeCard
      GROUP BY EmployeeID,CONVERT(VARCHAR(10),FromTime,102))E
```
  

  

For ur Question 2, I am not getting. give some more details about that. if possible send some sample data. if access over lap like (From date is 2013 -04-05 11:55:00PM to 2013-04-05 19:10:00PM)  

then we can't able to fine the time difference. So check the code for Question No 1 and give the feedback.  

  

Regards,  

GVPrabu hi@thebatswhiskersjust checking in on your half hourly usage issue?i think you’re also effected by the situation outlined in this topic, where i confirm:please be advised that there is a known issue effecting some customers, where half hourly usage information is not populating ontoonline usage graphs, despite good smart meter comms, and a populated monthly chart.if you haven’t already, we’d appreciated it if you could make oursupport teamaware of this, so a ‘case’ can be raised, helping us to identify the volumes of those effected. Hi, Really hard to work this out from your query but I suspect the answer would be a correlated sub query to find the latest appointment date.



https://www.geeksforgeeks.org/sql-correlated-subqueries/ welcome to mrexcel!

it actually works for me (see below). this appears to be a kind of rounding error. the way excel stores numbers causes some issues when you have decimals. it is a bit rare when comparing a cell to itself, but it can happen. you can try to use sumproduct instead, see column h.

efgh1valuescountifranksumproduct248737.76222336113.11333454287.76111f2:f4f2=countif($e$2:$e$4,">"&e2)+1g2:g4g2=rank.eq(e2,$e$2:$e$4)h2:h4h2=sumproduct(--(round($e$2:$e$4,2)>round(e2,2)))+1 java.sql.timestamp is a subclass of java.util.date - it should work the same for comparison purposes:

<https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/timestamp.html>

if you specifically need a date, you could convert it back pretty easily; check if isinstance(java.sql.timestamp… 1) form controls use a list box for the names of the conference rooms;use datetimepicker for scheduling the reservation...set the format property to custom;set the customformat property to mm dd yyyy hh mm ssof course, will also need ok button2) dataset up the data file like this:room date time1st floor, 6/8/21, 14:00:002nd floor, 6/9/21, 10:00:003rd floor, 6/8/21, 13:30:00reads these records from the file to determine if there is a conflict.if the room is available at the requested time, writes the reservation tothe file (in append mode) and displays a message box saying the reservationis complete. otherwise display a message box saying the room is unavailableat that time. how about this?

fn write\_some\_content(&mut self, hour: u32) -> result<(), std::io::error> {

if self.current\_hour != hour {

if let some(writer) = self.current\_file.as\_mut() {

writer.flush()?;

}

self.current\_file = none;

self.current\_hour = hour;

}

… it all varies depending on the team.if you’re close to production, pressure is high. outside of this there are a lot of variation, but in general people are working a lot. this is not really that there are explicit pressure to work long hours but many are very committed , and i think that when you are joining a team you’re more likely to pick up the same rythme.in terms of compensation, it depends on the role / the team and how much they want you after the on-site, but they will in general align on other offers you may have (from google/fb/apple/amazon/...) That's a great question...not sure what the answer is. My initial guess is they won't because it will show the assignment being turned in late. One thing I have done is to change the due date and then it extends the time for the students who came late into the class. That seems to help. if you had to pay in money when you filed then they are going to charge you interest for being late.

they are probably conducting an internal audit of all of your past returns right now, that is why you haven't gotten the notice yet. if they determine that you did this intentionally, which is likely, they'll access a punitive fine on top of the interest they'll charge you.

otherwise they might just send a warning. although it is illegal to file late, if you didn't owe them money they probably won't make a big deal out of it. just the same, they are probably auditing all of your recent returns.