converting time

[Guest]

Although I am not new to Access, I am self educated so my knowledge is
inconsistent. Before I begin, please know that I have read each and every
entry in both the reports and forms area, but most questions are much more
complicated and make assumptions.

My question is simple. I am trying to calculate the number of hours worked
in a time period.

TotalHrs=([ActualEnd]-[ActualStart])
7:00am to 11:45am results in 4:45

How can I convert this to 4.75

Thank you,

 

[Allen Browne]

Try:
DateDiff("n", [ActualStart], [ActualEnd]) / 60

 

[Guest]

Thank you for resonding. Before posting I tried...

=DateDiff("n",[ActualBegin],[ActualEnd])/60

But the response was 18:00
Since that was so different than the response I want, I never mentioned it.

Is it a field formatting problem?

Try:
DateDiff("n", [ActualStart], [ActualEnd]) / 60

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Although I am not new to Access, I am self educated so my knowledge is
inconsistent. Before I begin, please know that I have read each and every
entry in both the reports and forms area, but most questions are much more
complicated and make assumptions.

My question is simple. I am trying to calculate the number of hours
worked
in a time period.

TotalHrs=([ActualEnd]-[ActualStart])
7:00am to 11:45am results in 4:45

How can I convert this to 4.75

Thank you,

 

[Svein Ludvigsen]

Try
=DateDiff("n";[ActualBegin];[ActualEnd])/60

Svein

Thank you for resonding. Before posting I tried...

=DateDiff("n",[ActualBegin],[ActualEnd])/60

But the response was 18:00
Since that was so different than the response I want, I never mentioned
it.

Is it a field formatting problem?

Try:
DateDiff("n", [ActualStart], [ActualEnd]) / 60

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Although I am not new to Access, I am self educated so my knowledge is
inconsistent. Before I begin, please know that I have read each and
every
entry in both the reports and forms area, but most questions are much
more
complicated and make assumptions.

My question is simple. I am trying to calculate the number of hours
worked
in a time period.

TotalHrs=([ActualEnd]-[ActualStart])
7:00am to 11:45am results in 4:45

How can I convert this to 4.75

Thank you,

 

[Guest]

I did, but the resonse was
18:00

Any ideas???

Try
=DateDiff("n";[ActualBegin];[ActualEnd])/60

Svein

Thank you for resonding. Before posting I tried...

=DateDiff("n",[ActualBegin],[ActualEnd])/60

But the response was 18:00
Since that was so different than the response I want, I never mentioned
it.

Is it a field formatting problem?

Try:
DateDiff("n", [ActualStart], [ActualEnd]) / 60

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Although I am not new to Access, I am self educated so my knowledge is
inconsistent. Before I begin, please know that I have read each and
every
entry in both the reports and forms area, but most questions are much
more
complicated and make assumptions.

My question is simple. I am trying to calculate the number of hours
worked
in a time period.

TotalHrs=([ActualEnd]-[ActualStart])
7:00am to 11:45am results in 4:45

How can I convert this to 4.75

Thank you,

 

[Allen Browne]

There is a problem with the way your data is stored.

Perhaps you are not using a date/time field.
Perhaps your field contains dates as well as times.
Perhaps your formatting masks a problem between hr/min/sec.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I did, but the resonse was
18:00

Any ideas???

Try
=DateDiff("n";[ActualBegin];[ActualEnd])/60

Svein

Thank you for resonding. Before posting I tried...

=DateDiff("n",[ActualBegin],[ActualEnd])/60

But the response was 18:00
Since that was so different than the response I want, I never mentioned
it.

Is it a field formatting problem?

:

Try:
DateDiff("n", [ActualStart], [ActualEnd]) / 60

Although I am not new to Access, I am self educated so my knowledge
is
inconsistent. Before I begin, please know that I have read each and
every
entry in both the reports and forms area, but most questions are
much
more
complicated and make assumptions.

My question is simple. I am trying to calculate the number of hours
worked
in a time period.

TotalHrs=([ActualEnd]-[ActualStart])
7:00am to 11:45am results in 4:45

How can I convert this to 4.75

 

[Guest]

You're right. My [TotalHrs] Field was formatted as a Date/Time field. When
I changed it to a general format, it worked.
Thank you, Thank you, Thank you.

Rhonda

There is a problem with the way your data is stored.

Perhaps you are not using a date/time field.
Perhaps your field contains dates as well as times.
Perhaps your formatting masks a problem between hr/min/sec.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I did, but the resonse was
18:00

Any ideas???

Try
=DateDiff("n";[ActualBegin];[ActualEnd])/60

Svein

"R Marko" <[email protected]> skrev i melding
Thank you for resonding. Before posting I tried...

=DateDiff("n",[ActualBegin],[ActualEnd])/60

But the response was 18:00
Since that was so different than the response I want, I never mentioned
it.

Is it a field formatting problem?

:

Try:
DateDiff("n", [ActualStart], [ActualEnd]) / 60

Although I am not new to Access, I am self educated so my knowledge
is
inconsistent. Before I begin, please know that I have read each and
every
entry in both the reports and forms area, but most questions are
much
more
complicated and make assumptions.

My question is simple. I am trying to calculate the number of hours
worked
in a time period.

TotalHrs=([ActualEnd]-[ActualStart])
7:00am to 11:45am results in 4:45

How can I convert this to 4.75