Function TIME in calc

English
#1

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!

#2

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

#3

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.