Mar 31, 2011 #1 primagic IS-IT--Management Jul 24, 2008 476 GB Is there a way to add the letters (hrs) & (mins) to the following code: Code: =[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00")
Is there a way to add the letters (hrs) & (mins) to the following code: Code: =[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00")
Mar 31, 2011 #2 dhookom Programmer Jun 24, 2003 22,499 US How about: Code: =[Minutes] \ 60 & " Hrs " & Format([Minutes] Mod 60, "\:00") & " Mins" Duane Hook'D on Access MS Access MVP Upvote 0 Downvote
How about: Code: =[Minutes] \ 60 & " Hrs " & Format([Minutes] Mod 60, "\:00") & " Mins" Duane Hook'D on Access MS Access MVP
Mar 31, 2011 Thread starter #3 primagic IS-IT--Management Jul 24, 2008 476 GB Yes tried that already and it worked Upvote 0 Downvote