Calculated Field Please Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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")
 
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.
 
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...
 
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
 
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...
 
Back
Top