Create Sound when Time Elapses

[Papi]

I am diabetic and trying to get better control over my glucose readings. The doctor requested that I make every effort to take my glucose reading prior to a meal and take it again one hour after I eat that meal.

Cell G5 would ring one hour after F5 and I5 one hour after H5, and K5 after J5 but only one at a time. What I would like it to do is look at the last time i.e. H5 and one hour later ring an alarm. The next one could be I5 or K5 etc depending on which glucose readings are taken. Any help would be appreciated.

Diabetes.xlsm
	A	B	C	D	E	F	G	H	I	J	K
3	Date	SYS	DIA	PUL	Stat	AMBefore	AMAfter	MIDBefore	MIDAfter	PMBefore	PMAfter
4	Fri	132	93	84	HN	9.6	15.2	9.9
5	Jul08					8:05	9:17	12:28
Report

 

[GlennUK]

Is this any help:

http://www.j-walk.com/ss/excel/tips/tip87.htm

?

 

[Papi]

Hello Glenn,

Thanks for sending that. With my knowledge (actually-lack of knowledge) it has me baffled but that is not unusual for me. One of the areas that is an issue is that the target is moving as there are three times a day that the alarm could be triggered. I am messing around with the formula to attempt to get one cell to trigger such an alarm and this is what I have so far (in Cell Z5)

=IF(J5>0,J5+TIME(0,60,0),IF(H5>0,H5+TIME(0,60,0),IF(F5>0,F5+TIME(0,60,0),"")))

Not much to go on but at least a start.