Pop up alert

Closed
totzkie10 Posts 4 Registration date Friday June 21, 2013 Status Member Last seen July 9, 2013 - Jul 9, 2013 at 10:16 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 10, 2013 at 06:50 AM
Hello,

I have created a worksheet with macro to enter current time by clicking on a cell. For example, double click on A1 to enter current time then double click B1 to enter current time after processing a claim. The total minutes spent on that process will show in C1.

A1 B1 C1
0:09:00 0:09:30 0:00:30

I was just wondering if there is any code in excel that we can use so that after we enter the current time in A, excel will automatically calculate the minutes spent while working on a claim and there will be an alert if it has been more than 20 mins since it has started.

I have only set up conditional formatting in C that the cell will be in red once B is populated for the end time. Or is there anything similar to this effect.

thanks!



1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 10, 2013 at 06:50 AM
in c1 type the formula
=B1-A1
format col c as time
and copy the formula down

automaticallyl if A1 and B1 is entered nby your macro c will be filled.
0