Enter Start time and End Time

Closed
Report
Posts
4
Registration date
Friday June 21, 2013
Status
Member
Last seen
July 9, 2013
-
Posts
4
Registration date
Friday June 21, 2013
Status
Member
Last seen
July 9, 2013
-
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!

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
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
0
Posts
4
Registration date
Friday June 21, 2013
Status
Member
Last seen
July 9, 2013

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
0