TIME CALCULATIONS
Sirs,
Is it possible to calculate the time difference which im importing from different software. the data getting imported by following format. I want to calculate how much time he have taken lunch and break. if he have taken more than 1.30 lunch means how much time extra he have taken and break more than 15 minutes means how much time he have taken. is there is any formula for that A B C D E 9195 GOPALA KRISHNA .K ATTENDENCE 13-Oct-08 10:11:16 IN ATTENDENCE 13-Oct-08 10:11:18 IN ATTENDENCE 13-Oct-08 10:11:21 IN ATTENDENCE 13-Oct-08 12:37:18 OUT ATTENDENCE 13-Oct-08 14:10:13 IN ATTENDENCE 13-Oct-08 19:02:25 OUT ATTENDENCE 13-Oct-08 19:27:05 IN ATTENDENCE 13-Oct-08 21:41:42 OUT 9197 VENKATA RAO .V ATTENDENCE 13-Oct-08 9:58:09 IN ATTENDENCE 13-Oct-08 10:31:38 OUT ATTENDENCE 13-Oct-08 11:49:46 IN ATTENDENCE 13-Oct-08 11:49:48 IN ATTENDENCE 13-Oct-08 12:37:42 OUT ATTENDENCE 13-Oct-08 12:37:44 OUT ATTENDENCE 13-Oct-08 13:49:57 IN ATTENDENCE 13-Oct-08 13:50:00 IN ATTENDENCE 13-Oct-08 13:50:02 IN ATTENDENCE 13-Oct-08 13:50:05 IN ATTENDENCE 13-Oct-08 19:05:22 OUT ATTENDENCE 13-Oct-08 19:05:24 OUT ATTENDENCE 13-Oct-08 19:24:57 IN ATTENDENCE 13-Oct-08 19:24:59 IN ATTENDENCE 13-Oct-08 21:57:14 OUT -- srinivas |
TIME CALCULATIONS
Your data is bad, the "IN"s and "OUT"s don't match
Srinivas wrote: Sirs, Is it possible to calculate the time difference which im importing from different software. the data getting imported by following format. I want to calculate how much time he have taken lunch and break. if he have taken more than 1.30 lunch means how much time extra he have taken and break more than 15 minutes means how much time he have taken. is there is any formula for that A B C D E 9195 GOPALA KRISHNA .K ATTENDENCE 13-Oct-08 10:11:16 IN ATTENDENCE 13-Oct-08 10:11:18 IN ATTENDENCE 13-Oct-08 10:11:21 IN ATTENDENCE 13-Oct-08 12:37:18 OUT ATTENDENCE 13-Oct-08 14:10:13 IN ATTENDENCE 13-Oct-08 19:02:25 OUT ATTENDENCE 13-Oct-08 19:27:05 IN ATTENDENCE 13-Oct-08 21:41:42 OUT 9197 VENKATA RAO .V ATTENDENCE 13-Oct-08 9:58:09 IN ATTENDENCE 13-Oct-08 10:31:38 OUT ATTENDENCE 13-Oct-08 11:49:46 IN ATTENDENCE 13-Oct-08 11:49:48 IN ATTENDENCE 13-Oct-08 12:37:42 OUT ATTENDENCE 13-Oct-08 12:37:44 OUT ATTENDENCE 13-Oct-08 13:49:57 IN ATTENDENCE 13-Oct-08 13:50:00 IN ATTENDENCE 13-Oct-08 13:50:02 IN ATTENDENCE 13-Oct-08 13:50:05 IN ATTENDENCE 13-Oct-08 19:05:22 OUT ATTENDENCE 13-Oct-08 19:05:24 OUT ATTENDENCE 13-Oct-08 19:24:57 IN ATTENDENCE 13-Oct-08 19:24:59 IN ATTENDENCE 13-Oct-08 21:57:14 OUT |
All times are GMT +1. The time now is 11:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com