I'm trying to create a formula that adds 1 hr to a "time and date format", when i do cell+1 it only add to the date. Is this type of formula possible?
I'm trying to create a formula that adds 1 hr to a "time and date format", when i do cell+1 it only add to the date. Is this type of formula possible?
Hello and welcome to the forum,
Try cell+1/24
(24 hours = 1.0 in Excel)
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Hi, welcome to the forum
You need to understand this about dates...a date is just a number indicating how many days have passed since 1/1/1900, so 05/07/15 is actually 42131. excel formats it into something that we recognise as a date
Likewise with time...time is a decimal of 1 (day), so for instance 06:00 AM is actualy just 0.25, 12 noon is .05 and 06:00 PM (18:00) is 0.75. Again, excel formats it to something we see as a time
So to add 1 hour, probably the easiest way is =A1+1/24
(you could also use teh TIME() function
edit: GC got there before me
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
awesome perfect ty
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks