Ask Your Question
0

function TIME in calc [closed]

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

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
0

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

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

Stats

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

Seen: 263 times

Last updated: Dec 11 '13