Hi,
I have a data in G column which are in minutes as
G3 = 75
G4 = 260
G5 =125
I want to convert these into hour and minutes in H column as
H3=1 hour 15 min
H4=4 hour 20 min
H5=2 hour 5 minutes
Also,on doing sum in H6 =7 hours 40 min
And H7 is blank for next day data
Hoping a positive response in this regard.
You can do it with formulas.
Worksheet Formulas
Cell Formula H3 =G3/24/60 H4 =G4/24/60 H5 =G5/24/60 H6 =SUM(H3:H5)
Format the cells with a custom format:
h "hours" m "minutes"
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanx I got it.
Last edited by paradise2sr; 11-16-2017 at 02:49 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks