Dear All,
Actually in Excel i have difficulty in finding the difference between two times.
For example: assume that in 2000 i was working for around 16000 hrs 20 min 30 sec and in 2001, i have worked for 18000 hrs 45 min 13 sec (adding it from the previous year)
Now i want to calculate (in cell B6) like how many hours min and sec i worked in 2001 since 2000 in the format hhhh:mm:ss and i want to plot this in graph in the form of hhhh:mm:ss in the y-axis and year in the x-axis.
Kindly help!
Bookmarks