I am a Full-Stack Web & Software Developer with over fifteen years of experience. Over countless hours I have discovered that I have a passion and talent for creating works that are both highly functional and technically sound.

I have also discovered that I have a knack for understanding new theories & concepts – I am an adamant perfectionist when it comes to just about anything I do.

Current Skill set

  • Responsive Mobile first HTML & CSS3 – Bootstrap, SASS
  • JavaScript (Vanilla JS, JQuery, Angular)
  • PHP (Web Server & CRON)
  • CRM / CMS packages – WordPress, OsCommerce, Marketo
  • MySQL
  • Git
  • SEO & PPC
  • Java
  • Python
Legacy Technology
  • ASP (classic)
  • Visual Basic
  • Adobe Flash
Software Packages
  • Adobe Photoshop
  • MySQL
  • Jet Brains Web Suite
  • Microsoft Word
  • Microsoft Excel
  • Microsoft Access
  • Maya 3d
  • and more…


At the start of 2019, I am entering my 4th year of a 6 year course Studying a Bachelor of
Computer Science with gaming specialisation at Charles Sturt University



A license Pyrotechnician in the state of N.S.W. Australia for over twenty years, performing
professional grade pyrotechnic shows ranging from from Chinese String Crackers, Indoor Close
Proximity Fireworks, Aerial Shells up to 125mm and Aerial Salutes up to 75mm.

A founding member of the Pyrotechnics Industry Association of Australia (PIAA), Based in Sydney
but have performing shows all over NSW for all types of events.

Car Enthusiast

An active member in the Skylines Australia NSW car club I regularly volunteer to help run events.

Social Media

You can connect with me professionally on LinkedIn,
or stalk me through Twitter



Wizardry Fireworks

PRODOCOM Australia

Hannover Fairs Australia

E-Web Marketing

Freelance Websites

Personal Projects

Tipping Comp


National Pyrotechnics

iblott accessories


MS Excel: TIME() Function

Adjusting the time in Microsoft Excel is quite easily done and the TIME() function has a number of hooks that can be utilised to your advantage.

The date() function works by all parts the same

Understanding the way Excel uses TIME()

The formula for referencing the time set in A1 is as follows


Putting the above formula in cell B1 will give you the same time as set in A1.

Excel treats time as 3 separate pieces of data, these being Hour, Minute and Second.

You can set a particular element of time to whatever value you’d like. For example, If you have a time of 14:34:00 and only want use the hour of the day in A1 you would use


This is telling Excel to get the Hour from A1, but set the minute and second to 0 resulting in 14:00:00


will result in


Using Arithmetic in =TIME()

Knowing how the =TIME() function works, you can now perform arithmetic on the time.

Adding 3 hours to the time in A1 is simple by adding a +3 to the HOUR reference


Subtracting 3 hours to the time in A1 is simple by adding a -3 to the HOUR reference


Adding 3 hours to the time in A1 and rounding down to the hour is just by assigning 0 to the minute and second reference.


Getting Fancy

Rounding time off to the nearest hour: Using a simple ‘if else statement’ we can refer to the time in A1 and see if the minutes and seconds are greater than or equal to 30:00 and then round up or round down as required.

Published by
August 23, 2011 4:47 am

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.


I studied Digital Media for 12 months at Mt Druitt TAFE. While  doing so we studied The 3D Modeling Program ‘Maya’. During the course I produced a number of 3D scenes and a couple of 3D animated movies.

I have also played in other programs such as Bryce 3D, 3D Studio Max, Lightwave, Vue D’esprit and a few others. However, i have always returned to Maya as a personal preference.

Bellow are a number of works that i have produced from these various programs.

Bryce 3D: Balls

Vue D’esprit: Sulfuric

Maya: Living Room

Maya: Gauntlet