VBA: Extract minutes and hours to give an integer and decimal for cost calculation

[Animalised]

Hi Everyone,

I'm trying to speed up a process that is monotonous and unnecessary.

This may get long, so I apologise in advance. (I'm wrapping my head around this slowly).


I've managed to delete rows if a value = zero.

What I now need to do is delete a row if the Time Value in a cell is less than 00:06:00, I then need to check the entire column for the same reason.

(I will find out how to delete columns as that is the next stage, a little research)

Once rows with a cell value less than 00:06:00 have been deleted I need to extract the minutes of the time stated (i.e. 04:45:25, I need to pull "45" from that information and put it into a cell next to the 04:45:25 cell)

(I divide the minutes pulled by 60 to give me a decimal value that is added to the hours(4) stated "4", giving "4.75" to calculate cost)

So, like the minutes, I need to extract Hours and add those hours to the decimal minutes value from earlier.


If anyone is able to help with this, i would be more than thankful!

Thankyou again, and apologies that this is long!

 

[pgc01]

Hi

Not clear to me.

You mean that given

04:45:25

you will first discard the seconds

04:45:00

and then convert to decimal hours

4.75

?

What if it were

04:45:50

would you still consider

04:45:00

or, since it's closer

04:46:00

?

Also, would it not be OK to simple convert the time you have

04:45:25

to decimal hours?