Ask Your Question

function TIME in calc [closed]

asked 2013-12-11 17:43:48 +0200

altair gravatar image

Hello! Please, how can I calculate time difference between 23.15 and 0.11 h in calc cells?

23.15 is in one cell and 0.11 is in the next one.

How should I calculate the difference using function TIME? What do I have to put in the cells at all???

PLEASE HELP SOMONE!!! Many thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-16 16:25:40.401062

2 Answers

Sort by » oldest newest most voted

answered 2013-12-11 19:38:48 +0200

Pedro gravatar image

Just type 23:15 on the first cell, 00:11 on the second and =B1-A1 should give you 00:56:00 (i.e. 56 minutes) or formatted according to your other question 00.56

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-12-11 17:43:48 +0200

Seen: 274 times

Last updated: Dec 11 '13