Hi,
Following data appear in the cells A1,A2,A3 respectively.
9:15:59 AM
9:16:59 AM
9:17:59 AM
I just want to round it like 9:16 , 9:17 ,9:18 respectively.I just need to remove AM as well.
Can anyone help to construct formula?
Thanks,
Netaji
Hi,
Following data appear in the cells A1,A2,A3 respectively.
9:15:59 AM
9:16:59 AM
9:17:59 AM
I just want to round it like 9:16 , 9:17 ,9:18 respectively.I just need to remove AM as well.
Can anyone help to construct formula?
Thanks,
Netaji
You could use a formula in B1:
Formula:=ROUND(A1*24*60,0)/24/60
Then set the numberformat to h:mm
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks