Enter Start time and End Time Closed

Question

Hi! I'm trying to make a tracker using excel wherein we can calculate the minutes used in each task that we make. I am planning to have the start time under A, end time under B, total mins in C, then I'll have to enter other data on the following columns manually. I would like to create a shortcut or key to be able to enter the time faster. Please help. 

Thank you!

venkat1926 · Answer

not clear suppose data is like this A2 and B2


start	end
12:12:00	12:16:00
in C2 formula is 
=B2-A2
in D2 formula is 
=HOUR(C2)+MINUTE(C2)
copy C2 and D2 down even though there is no more data in col A
format columns D as number with no decimals. 

now you will get

start	ebnd	duration	"duration in
minutes"
12:12:00	12:16:00	0:04:00	4
		0:00:00	0
		0:00:00	0
		0:00:00	0
		0:00:00	0
		0:00:00	0
		0:00:00	0
		0:00:00	0
		0:00:00	0
		0:00:00	0
		0:00:00	0
		0:00:00	0

totzkie10 · Answer

I am thinking something like this as an output wherein we can assign a shortcut (ex: ctrl+Q for the current time to automatically be entered under start)

start	                 end	                 total mins
11:14:23 AM	11:14:27 AM	0:00:04

Enter Start time and End Time

2 responses

Similar discussions

Subscribe To Our Newsletter!