}
Home

Excel Macros and VBA Tips

Need Quick Excel Help? Have a question that needs to be answered? Looking for a quick VBA code/book/  add in/or template?

Send us the quick text and we can help

Break Excel VBA Password

Submitted by Support on Sat, 07/12/2008 - 20:42.

1. Create a new simple excel file.

Bookmark/Search this post with:

Convert time to a serial value in Microsoft Excel

Submitted by Support on Mon, 06/16/2008 - 15:38.

To covert time into a serial (numerical) value, enter in cell A1: 2342 (this represents the time 23:42)

Enter the following formula in cell B1: =(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2))+0

Bookmark/Search this post with:

eXTReMe Tracker