I have 3 columns - A(Total Mins), B(Hours) and C(Mins). If i have the value 310 in A1, i want to break this down as 5 in B1 and 10 in C1, meaning 310 total minutes can be broken down into 5 hrs and 10 mins.
I have obtained the C1 value by using =mod(A1,60).
How do i obtain B1?
Last edited by arlu1201; 10-06-2011 at 08:03 AM.
Try
=INT(A1/60)
B1 =int(a1/60)
c1 =mod(a1/60,1)*60
Thanks for the quick reply. It was so simple but i couldnt remember it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks