How to make formula in excel cell for time?

Solved/Closed
Ram - Mar 9, 2009 at 04:11 AM
 Excel dummy - Mar 12, 2010 at 06:22 PM
Hello,

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 esult in the following cell 12.01.05.

2 replies

Excel's time/date formats are cumulative in orders of single days. If you're adding an hour to your spreadsheet, your formula would simply add 1/24. If you're adding a minute it's 1/1440. So in order to have a cumulative column that adds five minutes every time you'd add 1/288 because 5 minutes is 1/288th of your day.
61
Tweedledum
Posts
181
Registration date
Monday January 19, 2009
Status
Member
Last seen
April 2, 2009
125
Mar 9, 2009 at 04:56 AM
Time can be a bit annoying in excel I think you might have to add the 5minutes in milliseconds to get the desired result but I am not completly sure. There are a load of great tutorials on this if you google Time calculations formaula excel you will get loads, heres a few examples

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=670

https://www.ozgrid.com/Excel/date-time-calculations.htm

the second one is a fairly good site for all things excel, though I would also google MR excel which is a great site where the forums are answered quite quickly and helpfully, I got an answer to a random thread I started within the hour which is a good time considering the answerer could be in a completly different timezone
8