Welcome Ted,
Please feel free to post your queries. Hope we all learn together
Warm regards,
Anand Kumar
On Oct 26, 7:47 pm, Ted wrote:
> Hi, just joined the group to take a look at what I could learn. I'll
> be posting any questions I have shortly.
--
---
Im glad you joined
On Oct 26, 2:47 pm, Ted wrote:
> Hi, just joined the group to take a look at what I could learn. I'll
> be posting any questions I have shortly.
--
--
Some important links for excel users:
1. F
I can't understand your issue...
You'll need only to format each cell properly and multiply the hour (HH:mm)
value by 24 hours (Excel converts automatically date and Time to decimal -
besides the display format).
See the attached file.
2009/6/4 Underdog
>
> Team,
>
> Is there a VBA or Fx that w
The problem was the cell format because time needs to be given as a
decimal (devide mins by 60) (+ round to 2 decimal points) and to do
that type the following:-
=[hourly rate cell reference] * (HOUR([Time Paid cell reference])+ROUND
(MINUTE([hourly rate cell reference] /60,2))
Problem solved.
