Hi everyone
i need to add number of hour to current time and date i enter in A2,B2 (which combined in C2) and the result will be in E2 As combined between date and time
Hi everyone
i need to add number of hour to current time and date i enter in A2,B2 (which combined in C2) and the result will be in E2 As combined between date and time
Change formula in C2
=A2+B2
Format as dd/mm/yyyy hh:mm
thanks JohnTopley for your effot
i found also this work good ,
=C2+D2/24
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks