Time Formula

[Mohamed Sameer Kazi]

Dear All,

Just need small help, How to Calculate time formula into minutes inf hours are more than hundread

e.g 148:20:05 HHH:MM:SS

the formula i am using is =((HOUR(L12)*60)+MINUTE(L12)+(SECOND(L12)/60))

but its taking only HH not HHH

Please help

Many Thanks
Mohamed Sameer

 

[Haz]

You can use (DAY(L12)*24+HOUR(L12))*60 or TEXT(L12,"[h]")*60 to get the full hours.

 

[Mohamed Sameer Kazi]

Thanks Haz,

it was a great help

you are a star...