# Excel time calculation and formatting

It’s actually really simple, but for some reason I just keep having to look up some of these… so… finally… note to self…

Calculations Time to decimal `=X+Y``=X+N``=Y-X`Etc. `12:45 - 9:55 = 2:50` `=X*24` `2:50 * 24 = 2.83` `=X/24` `2,83 / 24 = 2:50` `d h:mm` `11 19:20` `[h]:mm` `283:20` `[m]` `17000`

Regarding the formatting, without the brackets, it formats as regular time (`total hours % 24`). So, for example, 2 hours and 50 minutes multiplied by 100; with a regular time format (`h:mm`) it displays as 19:20; using brackets (`[h]:mm`) you get the correct 283:20, which is 11 days 19 hours and 20 minutes (hence the 19:20 from `h:mm`).

# Disappearing MS Word formatting

Got called up by a good friend today. She needed to gather the contents from various Word documents she had written during the year for her studies, into a single document to hand in at the end of the year.

The problem was that Word, for some weird reason, wouldn’t copy any of the formatting. No bold, no italic, tables were a mess…