not sure what formula

[Shawn]

I am trying to fix my pay sheet can you help. my time
gets added together as if the hour is a whole number and
the minute is a decimaland i can not get the number to
round up to the next whole number and leave the remaining
minutes less than an hour as a decimal

Example: 40.65 this is 41 hours and 5 minutes "41.05"

 

[Peo Sjoblom]

It would be a lot easier if you used excel time formats, to get 41.05 out of
40.65 you can use

=INT(A1)+HOUR(MOD(A1,1)/14.4)+(MINUTE(MOD(A1,1)/14.4)/100)

where A1 holds 40.65

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[shawn]

TY that did it. thanks again

-----Original Message-----
It would be a lot easier if you used excel time formats, to get 41.05 out of
40.65 you can use

=INT(A1)+HOUR(MOD(A1,1)/14.4)+(MINUTE(MOD(A1,1)/14.4)/100)

where A1 holds 40.65

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom




.