If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MOD Function or how to convert total minutes to hours and minutes
simple question.. maybe
i have a total number of minutes and i want to convert to hours and minutes.. example 125 total minutes i want it to be 2 hours and 5 minutes so i figured out how to change the minutes to hours i did = INT(([duration])/60) which gave me 2 how do i do the same with the remaining minutes i have tried = MOD (([duration]),60) but cant get it to work FYI duration is the field that has the total minutes' thanks you brad |
#2
|
|||
|
|||
Try:
=[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00") For an explanation, see: Calculating elapsed time at: http://members.iinet.net.au/~allenbrowne/casu-13.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Brad" wrote in message ... simple question.. maybe i have a total number of minutes and i want to convert to hours and minutes.. example 125 total minutes i want it to be 2 hours and 5 minutes so i figured out how to change the minutes to hours i did = INT(([duration])/60) which gave me 2 how do i do the same with the remaining minutes i have tried = MOD (([duration]),60) but cant get it to work FYI duration is the field that has the total minutes' thanks you brad |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Convert hours into days hours minutes | Alex | General Discussion | 1 | September 14th, 2004 06:29 PM |
Displaying total minutes in the form of hours and minutes | M | Worksheet Functions | 0 | August 2nd, 2004 07:40 PM |
Displaying a figure as days, hours and minutes | Arvi Laanemets | Worksheet Functions | 1 | January 16th, 2004 02:27 PM |
Convert hours and minutes into minutes | Jackie Parker | Worksheet Functions | 3 | December 9th, 2003 03:14 PM |
Convert 13 hours a 10 minutes to total minutes | John | Worksheet Functions | 2 | September 29th, 2003 04:07 PM |