Calculated Field Please Help

O

onropjack

I have a form i am using for data entry for a call center. I want to record
the total length of the call in minutes and seconds. I have a formula that
calculates the field as a minutes and decimal. I have tried simply changing
the format of the cell to a time format but nothing has work. Could i please
get some advice on calculated length of time and having the field appear in
my form?
 
R

Rick B

You would need to calculate the number of seconds, then change that to
DISPLAY as minutes and seconds. The following format should work...


=[SomeFieldInSeconds]\60 & Format([SomeFieldInSeconds] Mod 60,"\:00")
 
F

fredg

I have a form i am using for data entry for a call center. I want to record
the total length of the call in minutes and seconds. I have a formula that
calculates the field as a minutes and decimal. I have tried simply changing
the format of the cell to a time format but nothing has work. Could i please
get some advice on calculated length of time and having the field appear in
my form?
Click to expand...

As control source in an unbound control:
=DateDiff("s",[CallStart],[CallEnd])/60

The result will be in minutes plus the fractional part of a minute,
i.e. start at 12:00:00 and End at 12:06:15 returns 6.25 (6 and 1/4
minutes.
The calculation is NOT a time value so you cannot format it as time.
It is a Number value.
 
O

onropjack

so do you have a may to convert into minutes and seconds. I know formatting
wont do it automatically but is there formula i can use to convert it into
actual time.

fredg said:
I have a form i am using for data entry for a call center. I want to record
the total length of the call in minutes and seconds. I have a formula that
calculates the field as a minutes and decimal. I have tried simply changing
the format of the cell to a time format but nothing has work. Could i please
get some advice on calculated length of time and having the field appear in
my form?
Click to expand...

As control source in an unbound control:
=DateDiff("s",[CallStart],[CallEnd])/60

The result will be in minutes plus the fractional part of a minute,
i.e. start at 12:00:00 and End at 12:06:15 returns 6.25 (6 and 1/4
minutes.
The calculation is NOT a time value so you cannot format it as time.
It is a Number value.
Click to expand...
 
F

fredg

so do you have a may to convert into minutes and seconds. I know formatting
wont do it automatically but is there formula i can use to convert it into
actual time.

fredg said:
I have a form i am using for data entry for a call center. I want to record
the total length of the call in minutes and seconds. I have a formula that
calculates the field as a minutes and decimal. I have tried simply changing
the format of the cell to a time format but nothing has work. Could i please
get some advice on calculated length of time and having the field appear in
my form?
Click to expand...

As control source in an unbound control:
=DateDiff("s",[CallStart],[CallEnd])/60

The result will be in minutes plus the fractional part of a minute,
i.e. start at 12:00:00 and End at 12:06:15 returns 6.25 (6 and 1/4
minutes.
The calculation is NOT a time value so you cannot format it as time.
It is a Number value.
Click to expand...
Click to expand...

Start at 12:00:00 and End at 12:06:15

= Int(DateDiff("s",[CallStart],[CallEnd])/60) & ":" &
DateDiff("s",[CallStart],[CallEnd]) Mod 60
6:15
 
R

Rick B

Did you not even read my post with the formula?


--
Rick B



onropjack said:
so do you have a may to convert into minutes and seconds. I know formatting
wont do it automatically but is there formula i can use to convert it into
actual time.

fredg said:
I have a form i am using for data entry for a call center. I want to record
the total length of the call in minutes and seconds. I have a formula that
calculates the field as a minutes and decimal. I have tried simply changing
the format of the cell to a time format but nothing has work. Could i please
get some advice on calculated length of time and having the field appear in
my form?
Click to expand...

As control source in an unbound control:
=DateDiff("s",[CallStart],[CallEnd])/60

The result will be in minutes plus the fractional part of a minute,
i.e. start at 12:00:00 and End at 12:06:15 returns 6.25 (6 and 1/4
minutes.
The calculation is NOT a time value so you cannot format it as time.
It is a Number value.
Click to expand...
Click to expand...
 
Top