Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Calculations | Excel Discussion (Misc queries) | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Overlapping time calculations and automatic time updates | Excel Worksheet Functions | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
time calculations | Excel Discussion (Misc queries) |