Enter Start time and End Time

Closed
totzkie10 Posts 4 Registration date Friday June 21, 2013 Status Member Last seen July 9, 2013 - Jun 21, 2013 at 05:42 PM
totzkie10 Posts 4 Registration date Friday June 21, 2013 Status Member Last seen July 9, 2013 - Jun 22, 2013 at 11:04 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jun 21, 2013 at 11:05 PM
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
totzkie10 Posts 4 Registration date Friday June 21, 2013 Status Member Last seen July 9, 2013
Jun 22, 2013 at 11:04 AM
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