Search:

Perfect, thanks for all your help.

Please see the attached sheet, i need to calculate the no events in each shift

Shift A - 8.31 PM - 4.30 AM
Shift B - 4.31 AM - 12.30 PM
Shift C - 12.31 PM - 8.30 PM

Perfect, thanks for all your help, its working as expected.

Sample file attached, please help.

Thanks, however no luck it gives #VALUE!

Please help to subtract the start time minus end time , it will help me to calculate the actual time taken.



formattedClosedDate
formattedStartTime


Aug 17, 2016, 7:28:14 AM
Aug 17, 2016,...

Perfect, thanks for all your help !!!

It works, just that it is picking the time only in AM, even if it is PM

Just realized that date and time is not always at the end, it's anywhere in the column, please help to extract it from the below text.

Current count 119. Keeping under monitoring. Admin.Tausif Aug...

Yes did adjusted the right cell, anyways the sheet that you have sent works perfectly fine, so copied over the data onto it and moved the results back to the original sheet, thanks for all your help.

Thanks, not sure if it is running or not, gives #VALUE!

This is how my text looks like.
Unable to identify the source system. The user account seems to be a service account for Rancid which is a config backup software. Tausif.Shaikh Aug 8, 2016, 3:12:50...