excel - I need to add 3 hours to a date + a time -
i have column each cell has date , time in it
4/12/14 8:35 pm
i want add 3 hours time each cell.
in end, be: 4/12/14 11:35 pm
what's quickest way this?
- consider =a1+3/24 -– simoco
- use cell formatting display full date , time -- nazim
Comments
Post a Comment