google docs spreadsheet tips

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.

Related Posts by Categories