d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Excel Macro Question
Add Reply New Topic New Poll
Member
Posts: 27,539
Joined: Jun 20 2007
Gold: 25,000.25
Jun 20 2012 12:36pm
Working on a macro that just enters the time into the cell I have highlighted when I hit a button. Currently the macro adds in the time as hh:mm:ss. I formatted it to just show hh:mm. The problem is one of my formulas checks to see if one clock in time hh:mm equals another and then ends the function. When I entered it manually hh:mm it worked fine. But now that seconds are in the background they never equal eachother. What's my best option?

Member
Posts: 27,539
Joined: Jun 20 2007
Gold: 25,000.25
Jun 20 2012 01:39pm
Well. I may have figured out a workaround for that however it messed up another one of my formulas... Ugh. They don't pay me enough.
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll