LinkBack URL
About LinkBacks
hello to all,
i want to calculate late comming of wrokers in minutes, for eg. in some one is late for 1.45 mins. (ie 1hrs and 45mins) , i want to convert in into 105 mins,
hello to all,
i want to calculate late comming of wrokers in minutes, for eg. in some one is late for 1.45 mins. (ie 1hrs and 45mins) , i want to convert in into 105 mins,
Try
=INT(A1)*60+MOD(A1,1)*100
Life's a spreadsheet, Excel!
Say thanks, Click *
Assuming you have 1.45 in cell A1 then try this......
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
=60*dollarde(a1,60)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks