Mar 31, 2011 #1 primagic IS-IT--Management Joined Jul 24, 2008 Messages 476 Location 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 Joined Jun 24, 2003 Messages 22,561 Location 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 Joined Jul 24, 2008 Messages 476 Location GB Yes tried that already and it worked Upvote 0 Downvote