Military time in excel

[priceassist]

I am working on a spreadsheet and my column E is my start time and column F is my stop time and i need to calculate the minutes in column G. =F-E=G doesn't always work. The time is military time and I want to be able to formulate it without needing to put the colons in. I want to be able to program the spreadsheet so when i plug in the start and atop time column G automatically calculates.

Start Stop Min
0827 1137
1158 1402
1438 1533
Total

0702 0814
0835 1137
1239 1534
1555 1737
1807 1914
1934 2118
Total

<colgroup><col span="4"></colgroup><tbody>
</tbody>

 

[Jonmo1]

Yes it does, if it is text (which I suspect it is), but not if it is real time

It appears to me that they are Numbers Stored As Text...Not real time (hence user saying doesn't want to enter it with a
It works either way anyway. Whether they are real numbers (1137) or Numbers Store As Text (0827)

We know that they are NOT real time values, as the OP said he did not enter them with the :

 

[FDibbins]

Very true, Jonmo, and nice formula

	A​	B​	C​
2​	0827	1137	190​
3​	8:27​	11:37​	0​
4​	827​	1137​	190​

 

[priceassist]

Welcome to the board.

Try
=(TEXT(B2,"00\:00")-TEXT(A2,"00\:00"))*1440

A2 is Start Time, B2 is End Time.

THANK YOU!!!! this worked!

 

[Jonmo1]

You're welcome.

 

[priceassist]

This worked!!!! Thank you!

 

[priceassist]

Since you were able to figure out the last question I had, I have another!!! So, some of the case times I need to figure out go from one day to the next.

2200	0135
2200	2325
2200	0135
2200	0408

<colgroup><col span="2"></colgroup><tbody>
</tbody>

SO.... tried to figure it out but I gave up!

Thanks for ANY help!

 

[Jonmo1]

Try

=MOD((TEXT(B2,"00\:00")-TEXT(A2,"00\:00"))*1440,1)

 

[priceassist]

Try

=MOD((TEXT(B2,"00\:00")-TEXT(A2,"00\:00"))*1440,1)

This formula gave me all 0000....... have something else i could try??!!!

Thank you!!

 

[Jonmo1]

I didn't close the mod correctly

try

=MOD((TEXT(B2,"00\:00")-TEXT(A2,"00\:00")),1)*1440

 

[priceassist]

THANK YOU!!!!! This worked, I really appreciate the help.