Help with Complicated time calculations- Separating hours and minutes

[Eean]

Hi,
I have a calculator I'm working on in excel to calculate a figure from an hourly rate.
I have a cell which adds up the sum of the total minutes in column b.
I have another cell which converts this to hours and minutes by using C19/1440
I need to be able to do a calculation for the whole hours and a separate calculation for the minutes. Is there any way to take the the hour convert it to a number in one cell and take the minutes and convert it to a number in another cell?

(I realise this sounds over complicated, but i'm trying to imitate the way that a Local Council do their calculations. For example they calculate:
3 hours x (£hourly rate)
+
40mins (0.66 x £hourly rate)
= £end figure

I'd just divide the hourly rate by 60 and times by the number of minutes, but the figures come out differently. and they have passed these back as incorrect when submitted)

 

[diddi]

shouldnt your minutes to hours conversion be =C19/60 ?
you have done minutes to days...

if C19 is, in fact minutes, then
Hours part = Int(C19/60)
minutes part = c19 - Int (C19/60)

 

[Eean]

shouldnt your minutes to hours conversion be =C19/60 ?
you have done minutes to days...

if C19 is, in fact minutes, then
Hours part = Int(C19/60)
minutes part = c19 - Int (C19/60)

C19 is formatted (perhaps wrongly) as number to 0 decimal places for ease of entry. When formatted to mm, "45" (as in 45 minutes) shows as 02 and in the formula bar there is a date rather than a time. When you divide the C19 (formatted in Number) by 1440 it comes out in Hours and minutes. (I'm not sure why)

I think I've been unclear about what I'm trying to achieve. Say, C19 is showing as 3:40 - I want one cell to show the 3 and another cell to show the 40.

 

[T. Valko]

C19 is formatted (perhaps wrongly) as number to 0 decimal places for ease of entry. When formatted to mm, "45" (as in 45 minutes) shows as 02 and in the formula bar there is a date rather than a time. When you divide the C19 (formatted in Number) by 1440 it comes out in Hours and minutes. (I'm not sure why)

I think I've been unclear about what I'm trying to achieve. Say, C19 is showing as 3:40 - I want one cell to show the 3 and another cell to show the 40.

Try these...

For the hour:

=HOUR(C19)

For the minutes:

=MINUTE(C19)

 

[Eean]

Try these...

For the hour:

=HOUR(C19)

For the minutes:

=MINUTE(C19)

Brilliant! Worked a treat! Thanks!

 

[T. Valko]

Brilliant! Worked a treat! Thanks!

You're welcome. Thanks for the feedback!