LinkBack URL
About LinkBacks
I want to make spread sheet with time in the Excel CELL How to do that? For example 1st cell should show 11hrs.56mins.05sec and next cell i want enter 5 min, i want to make addition and get the result in the following cell 12.01.05.
I want to make spread sheet with time in the Excel CELL How to do that? For example 1st cell should show 11hrs.56mins.05sec and next cell i want enter 5 min, i want to make addition and get the result in the following cell 12.01.05.
Please try this file.
Last edited by ramananhrm; 09-20-2013 at 08:24 AM.
Please click 'Add reputation', if my answer helped you.
if you have data in A1 & A2 and you need result in a3 simply use =A1+A2
The point is that you have to enter any Time in the correct Format, i.e.:
11:56:05 + 00:05:00 = 12:01:05 PM
Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks