all time in column b and C in format military
i would like to add hour from D3 to B2 and put this function in C3
please kindly find attached file
all time in column b and C in format military
i would like to add hour from D3 to B2 and put this function in C3
please kindly find attached file
Hi
I suppose you can use =D3+B2
Hi
I suppose you can use =D3+B2
Excel can handle military time, just set the right format.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Try this ...
=TEXT(B2,"00\:00")+TEXT(D3,"00\:00")
Format cells -> [h]:mm
thanks all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks