Thread: Time and Date add error..

Hi, i work offshore and i created a sporeadsheet to help with my work. I have to add tha hours i spent doing each thing but if i started something, let's say, yesterday at 23:00 and finished it the following day at 2:00 i have to insert the value manually.. check the pic below.

http://img860.imageshack.us/img860/8678/exceldoubt.jpg

Uploaded with ImageShack.us

Try the following cell format in total:

[hh]:mm:ss

edvwvw