time tracking.

[Anas_Raza]

i have a sheet in which i write my daily routine work and its time.

Example:

Date: zuhar fajir asir
14-2-15 12:00 12:30 12:40


i can design a peviot table when i press refresh button then it tell me next event is fajir or asir and time remaining in "value of time".

 

[Anas_Raza]

please think about this thread.
if any one have some confusion then tell me
but think about it.