Get the difference between two dates:
In the following, G2 is a date (e.g. 12/31/2013), B2 (is a starting time [HH:MM:SS]), C2 (is a ending time [HH:MM:SS])
=(to_date(CONCATENATE(G2," ",C2))-to_date(CONCATENATE(G2," ",B2))) * 24
Truncating number of decimal places:
If cell H2 contains "0.016666666666667" then using =trunc(H3;3) will result in 0.016.
If cell H2 contains "0.016666666666667" then using =trunc(H3;2) will result in 0.01.
Rounding number of decimal places:
If cell H2 contains "0.016666666666667" then using =round(H3;3) will result in 0.017.
If cell H2 contains "0.016666666666667" then using =round(H3;2) will result in 0.02.
