Thursday, August 21, 2014

Excel formula to show difference of time in proper format


There are 2 columns in my excel which tells 2 times say EndTime and StartTime. I have to show the difference between these 2 columns in next column.


If the EndTime is in column B and StartTime is in column A and want to show the difference in column C

Just use the cell formula =B1-A1 in the C1 cell apply the same formula to all the cells by simply dragging.

In the normal scenario we can see the difference in h:mm:ss format. But actually speaking we are not telling column C that the format should be h:mm:ss. This leaves an option in future that the difference may be shown as decimal number. So how to include the same in cell formula.

Use =TEXT(B1-A1,"h:mm:ss")

Thursday, April 24, 2014

Installing Win 8.1 in USB drive and advantages of Win 8.1


How to install Windows To Go in USB

I strongly suggest to try this using USB 3.0 external hard drives or Pen drives on your machine's USB 3.0 port. Otherwise it will become useless as the data transfer speed is very low

If we simply boot from USB drive and try to install Windows 8.1,it will end up in a message as follows.

You can’t install Windows on a USB flash drive from Setup. Error code: 0xc1900104

So what we can do. The solution is Windows to go.This will help us to setup the OS in the USB disk with in 3 major steps, if we already running Windows 7 OS and have the Win8.1 ISO obtained.

What we need

  • Windows 8.1 .iso image
  • GimageX
  • Machine which supports USB 3.0 & booting from USB 
  • USB 3.0 disk with at least 32 GB


  • Setup the primary partition in the USB disk .Make it active. Lets say it's drive letter is O:\
    • I don't think, I should explain how this can be done as its common already.
  • Apply file
    • Make sure the Win 8.1 ISO file is mounted using any disc management software such as MagicDisk.Lets say mounted drive letter is D:\
    • Download GIamgeX utility and apply/install the install.wim file present in Win 8.1 iso into USB.The path to install.wim will be d:\sources\Install.wim
      • This will take some time and copy required files into our USB drive including O:\Windows
  • Next install the boot manager.
    • O:\Windows\System32\bcdboot.exe O:\Windows /s O: (Here we are using the bcdboot utility of win 8 itself
      • If this is not working if you run from windows folder. Copy the bcdboot.exe from Windows 8 system folder to your Windows 7 desktop and try the same.
  • [Optional] Now reboot the machine. Have required changes in BIOS to boot from the USB disk. If its not booting Windows 8.1 and showing error message, follow the below step after logging into old Windows 7 which is installed in internal hard disk.
    • O:\Windows\System32\bootsect.exe /nt60 O: (This will correct the master boot code)
This is the way I tried. Of course there are many more ways. I was not able to complete my installation by looking at one single tutorial. That's why I thought of posting my experience. Some of those are listed below.