Hello all,

I am a transcriber. Let's say, I start transcribing an audio at 11:30 PM and
the audio is 60 minutes long. I have to transcribe a minute of the audio (one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes should
take me three hours, which means my deadline is 2:30 AM. I should have
finished my job by 2:30 AM. Can someone help me out in generating a formula
which will calculate the deadline time? Thanks

A1 (Audio Start Time) : 11:30 PM ; B1 (Audio End Time) = 12:30 AM ; C1
(Duration of the audio) [B1-A1] = 60 mins; D1 (Deadline) = ??? --- where
deadline is, duration multiplied by 3, the resultant converted to hours and
added to the start time.

I understand that there is a high probability of getting confused. Please
let me know.

Thanks

"Mark Fergie" wrote:

Hello all,

I am a transcriber. Let's say, I start transcribing an audio at 11:30 PM and
the audio is 60 minutes long. I have to transcribe a minute of the audio (one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes should
take me three hours, which means my deadline is 2:30 AM. I should have
finished my job by 2:30 AM. Can someone help me out in generating a formula
which will calculate the deadline time? Thanks

Mark;

In cell D1 type =(C1*3)+A1. You may want to get into a little more
formatting. I had to format my cells to military time so as to calculate
accurately. When you enter pm time just enter the letter P after the time.
Anything without a P will default to AM.

God Bless

Frank Pytel

"Mark Fergie" wrote:

A1 (Audio Start Time) : 11:30 PM ; B1 (Audio End Time) = 12:30 AM ; C1
(Duration of the audio) [B1-A1] = 60 mins; D1 (Deadline) = ??? --- where
deadline is, duration multiplied by 3, the resultant converted to hours and
added to the start time.

I understand that there is a high probability of getting confused. Please
let me know.

Thanks

"Mark Fergie" wrote:

Hello all,

I am a transcriber. Let's say, I start transcribing an audio at 11:30 PM and
the audio is 60 minutes long. I have to transcribe a minute of the audio (one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes should
take me three hours, which means my deadline is 2:30 AM. I should have
finished my job by 2:30 AM. Can someone help me out in generating a formula
which will calculate the deadline time? Thanks

Hi Mark,

Maybe try
C1: =IF(A1B1,B1+1-A1,B1-A1)
D1: =C1*3
and format C1 and D1 as custom [hh]:mm

It all really depends on the way you input your times.

HTH
Martin



"Mark Fergie" wrote in message
...
A1 (Audio Start Time) : 11:30 PM ; B1 (Audio End Time) = 12:30 AM ; C1
(Duration of the audio) [B1-A1] = 60 mins; D1 (Deadline) = ??? --- where
deadline is, duration multiplied by 3, the resultant converted to hours
and
added to the start time.

I understand that there is a high probability of getting confused. Please
let me know.

Thanks

"Mark Fergie" wrote:

Hello all,

I am a transcriber. Let's say, I start transcribing an audio at 11:30 PM
and
the audio is 60 minutes long. I have to transcribe a minute of the audio
(one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes
should
take me three hours, which means my deadline is 2:30 AM. I should have
finished my job by 2:30 AM. Can someone help me out in generating a
formula
which will calculate the deadline time? Thanks

Correction. That should be,
D1: =A1+(C1*3)

HTH
Martin


"MartinW" wrote in message
...
Hi Mark,

Maybe try
C1: =IF(A1B1,B1+1-A1,B1-A1)
D1: =C1*3
and format C1 and D1 as custom [hh]:mm

It all really depends on the way you input your times.

HTH
Martin



"Mark Fergie" wrote in message
...
A1 (Audio Start Time) : 11:30 PM ; B1 (Audio End Time) = 12:30 AM ; C1
(Duration of the audio) [B1-A1] = 60 mins; D1 (Deadline) = ??? --- where
deadline is, duration multiplied by 3, the resultant converted to hours
and
added to the start time.

I understand that there is a high probability of getting confused. Please
let me know.

Thanks

"Mark Fergie" wrote:

Hello all,

I am a transcriber. Let's say, I start transcribing an audio at 11:30 PM
and
the audio is 60 minutes long. I have to transcribe a minute of the audio
(one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes
should
take me three hours, which means my deadline is 2:30 AM. I should have
finished my job by 2:30 AM. Can someone help me out in generating a
formula
which will calculate the deadline time? Thanks

It doesn't seem to work. This is how I calculated C1 (Duration)
=(B1-A1)+IF(B1<A1,1) --- with a custom formatting of [mm]. But even if i
enter the duration manually and change the formatting of A1 and B1, it
doesn't give me the exact value. It gives me a value of 26:30. Is there a way
i can do it in AM/PM format. I remember doing it sometime back, but just
can't get it. Thanks. Your help will be greatly appreciated.

"Frank Pytel" wrote:

Mark;

In cell D1 type =(C1*3)+A1. You may want to get into a little more
formatting. I had to format my cells to military time so as to calculate
accurately. When you enter pm time just enter the letter P after the time.
Anything without a P will default to AM.

God Bless

Frank Pytel

"Mark Fergie" wrote:

A1 (Audio Start Time) : 11:30 PM ; B1 (Audio End Time) = 12:30 AM ; C1
(Duration of the audio) [B1-A1] = 60 mins; D1 (Deadline) = ??? --- where
deadline is, duration multiplied by 3, the resultant converted to hours and
added to the start time.

I understand that there is a high probability of getting confused. Please
let me know.

Thanks

"Mark Fergie" wrote:

Hello all,

I am a transcriber. Let's say, I start transcribing an audio at 11:30 PM and
the audio is 60 minutes long. I have to transcribe a minute of the audio (one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes should
take me three hours, which means my deadline is 2:30 AM. I should have
finished my job by 2:30 AM. Can someone help me out in generating a formula
which will calculate the deadline time? Thanks

It doesn't seem to work. This is how I calculated C1 (Duration)
=(B1-A1)+IF(B1<A1,1) --- with a custom formatting of [mm]. I tried your idea,
but doesn't seem to work. Can you be a bit specific about formatting -- how I
enter times. I remember doing it sometime back in AM/PM, but just can't get
it. Thanks. Your help will be greatly appreciated.

"MartinW" wrote:

Hi Mark,

Maybe try
C1: =IF(A1B1,B1+1-A1,B1-A1)
D1: =C1*3
and format C1 and D1 as custom [hh]:mm

It all really depends on the way you input your times.

HTH
Martin



"Mark Fergie" wrote in message
...
A1 (Audio Start Time) : 11:30 PM ; B1 (Audio End Time) = 12:30 AM ; C1
(Duration of the audio) [B1-A1] = 60 mins; D1 (Deadline) = ??? --- where
deadline is, duration multiplied by 3, the resultant converted to hours
and
added to the start time.

I understand that there is a high probability of getting confused. Please
let me know.

Thanks

"Mark Fergie" wrote:

Hello all,

I am a transcriber. Let's say, I start transcribing an audio at 11:30 PM
and
the audio is 60 minutes long. I have to transcribe a minute of the audio
(one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes
should
take me three hours, which means my deadline is 2:30 AM. I should have
finished my job by 2:30 AM. Can someone help me out in generating a
formula
which will calculate the deadline time? Thanks

D1 still shows a value of 26:30, and moreover I want C1 in minutes.

"MartinW" wrote:

Correction. That should be,
D1: =A1+(C1*3)

HTH
Martin


"MartinW" wrote in message
...
Hi Mark,

Maybe try
C1: =IF(A1B1,B1+1-A1,B1-A1)
D1: =C1*3
and format C1 and D1 as custom [hh]:mm

It all really depends on the way you input your times.

HTH
Martin



"Mark Fergie" wrote in message
...
A1 (Audio Start Time) : 11:30 PM ; B1 (Audio End Time) = 12:30 AM ; C1
(Duration of the audio) [B1-A1] = 60 mins; D1 (Deadline) = ??? --- where
deadline is, duration multiplied by 3, the resultant converted to hours
and
added to the start time.

I understand that there is a high probability of getting confused. Please
let me know.

Thanks

"Mark Fergie" wrote:

Hello all,

I am a transcriber. Let's say, I start transcribing an audio at 11:30 PM
and
the audio is 60 minutes long. I have to transcribe a minute of the audio
(one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes
should
take me three hours, which means my deadline is 2:30 AM. I should have
finished my job by 2:30 AM. Can someone help me out in generating a
formula
which will calculate the deadline time? Thanks

Hi Mark,

Try it like this
C1: =IF(A1B1,B1+1-A1,B1-A1) formatted as custom [hh]:mm
D1: =A1+(C1*3) formatted as custom h:mm AM/PM

Input your times in A and B as
11:30 pm
2:25 am
etc.
making sure you include the space.

HTH
Martin

"Mark Fergie" wrote in message
...
It doesn't seem to work. This is how I calculated C1 (Duration)
=(B1-A1)+IF(B1<A1,1) --- with a custom formatting of [mm]. I tried your
idea,
but doesn't seem to work. Can you be a bit specific about formatting --
how I
enter times. I remember doing it sometime back in AM/PM, but just can't
get
it. Thanks. Your help will be greatly appreciated.

"MartinW" wrote:

Hi Mark,

Maybe try
C1: =IF(A1B1,B1+1-A1,B1-A1)
D1: =C1*3
and format C1 and D1 as custom [hh]:mm

It all really depends on the way you input your times.

HTH
Martin



"Mark Fergie" wrote in message
...
A1 (Audio Start Time) : 11:30 PM ; B1 (Audio End Time) = 12:30 AM ; C1
(Duration of the audio) [B1-A1] = 60 mins; D1 (Deadline) = ??? ---
where
deadline is, duration multiplied by 3, the resultant converted to hours
and
added to the start time.

I understand that there is a high probability of getting confused.
Please
let me know.

Thanks

"Mark Fergie" wrote:

Hello all,

I am a transcriber. Let's say, I start transcribing an audio at 11:30
PM
and
the audio is 60 minutes long. I have to transcribe a minute of the
audio
(one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes
should
take me three hours, which means my deadline is 2:30 AM. I should have
finished my job by 2:30 AM. Can someone help me out in generating a
formula
which will calculate the deadline time? Thanks

Hey, you're amazing...thanks a heap. Works fantastic. Value for money!!!

"MartinW" wrote:

Hi Mark,

Try it like this
C1: =IF(A1B1,B1+1-A1,B1-A1) formatted as custom [hh]:mm
D1: =A1+(C1*3) formatted as custom h:mm AM/PM

Input your times in A and B as
11:30 pm
2:25 am
etc.
making sure you include the space.

HTH
Martin

"Mark Fergie" wrote in message
...
It doesn't seem to work. This is how I calculated C1 (Duration)
=(B1-A1)+IF(B1<A1,1) --- with a custom formatting of [mm]. I tried your
idea,
but doesn't seem to work. Can you be a bit specific about formatting --
how I
enter times. I remember doing it sometime back in AM/PM, but just can't
get
it. Thanks. Your help will be greatly appreciated.

"MartinW" wrote:

Hi Mark,

Maybe try
C1: =IF(A1B1,B1+1-A1,B1-A1)
D1: =C1*3
and format C1 and D1 as custom [hh]:mm

It all really depends on the way you input your times.

HTH
Martin



"Mark Fergie" wrote in message
...
A1 (Audio Start Time) : 11:30 PM ; B1 (Audio End Time) = 12:30 AM ; C1
(Duration of the audio) [B1-A1] = 60 mins; D1 (Deadline) = ??? ---
where
deadline is, duration multiplied by 3, the resultant converted to hours
and
added to the start time.

I understand that there is a high probability of getting confused.
Please
let me know.

Thanks

"Mark Fergie" wrote:

Hello all,

I am a transcriber. Let's say, I start transcribing an audio at 11:30
PM
and
the audio is 60 minutes long. I have to transcribe a minute of the
audio
(one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes
should
take me three hours, which means my deadline is 2:30 AM. I should have
finished my job by 2:30 AM. Can someone help me out in generating a
formula
which will calculate the deadline time? Thanks

You're welcome Mark, glad I could help.


"Mark Fergie" wrote in message
...
Hey, you're amazing...thanks a heap. Works fantastic. Value for money!!!

"MartinW" wrote:

Hi Mark,

Try it like this
C1: =IF(A1B1,B1+1-A1,B1-A1) formatted as custom [hh]:mm
D1: =A1+(C1*3) formatted as custom h:mm AM/PM

Input your times in A and B as
11:30 pm
2:25 am
etc.
making sure you include the space.

HTH
Martin

"Mark Fergie" wrote in message
...
It doesn't seem to work. This is how I calculated C1 (Duration)
=(B1-A1)+IF(B1<A1,1) --- with a custom formatting of [mm]. I tried your
idea,
but doesn't seem to work. Can you be a bit specific about formatting --
how I
enter times. I remember doing it sometime back in AM/PM, but just can't
get
it. Thanks. Your help will be greatly appreciated.

"MartinW" wrote:

Hi Mark,

Maybe try
C1: =IF(A1B1,B1+1-A1,B1-A1)
D1: =C1*3
and format C1 and D1 as custom [hh]:mm

It all really depends on the way you input your times.

HTH
Martin



"Mark Fergie" wrote in message
...
A1 (Audio Start Time) : 11:30 PM ; B1 (Audio End Time) = 12:30 AM ;
C1
(Duration of the audio) [B1-A1] = 60 mins; D1 (Deadline) = ??? ---
where
deadline is, duration multiplied by 3, the resultant converted to
hours
and
added to the start time.

I understand that there is a high probability of getting confused.
Please
let me know.

Thanks

"Mark Fergie" wrote:

Hello all,

I am a transcriber. Let's say, I start transcribing an audio at
11:30
PM
and
the audio is 60 minutes long. I have to transcribe a minute of the
audio
(one
minute of speaking in the audio) in 3 actual minutes. So 60 minutes
should
take me three hours, which means my deadline is 2:30 AM. I should
have
finished my job by 2:30 AM. Can someone help me out in generating a
formula
which will calculate the deadline time? Thanks